SQL 7.0 Backup/Restore , Maybe I am nuts 
Author Message
 SQL 7.0 Backup/Restore , Maybe I am nuts

Hello,

I am using MSDE for this adventure. I have backed up a database from another
server. this is a sql server 7.0 server. I ran the backup to a backup
device.

Then I copy the backup file to the MSDE box. I run the restore process on
the MSDE server and get the error,

the file .... cannot be used be used by restore. Consider using the with
move option ...

I am perplexed. I am simply trying to restore a backup from one server to
another. I am practicing for a server faliure in the exent i need to swap
out machines when one fails.

I am using MSDE as my restoreing server but that should not  matter. What i
thought would be easy is not.

Any help would be qappreciated.

Scott Ocamb



Wed, 05 Dec 2001 03:00:00 GMT
 SQL 7.0 Backup/Restore , Maybe I am nuts

If you do not restore in the same directory and drive you need to use
RESTORE WITH MOVE as described in the Books Online.

-GertD



Wed, 05 Dec 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Backup/restore from SQL 7.0 Server to SQL 7.0 SP1 Server

2. Restoring msdb database from SQL Server 7.0 backup to SQL Server 2000

3. Restoring SQL 7.0 backup to SQL 2000

4. Help - restore backup file from SQL server 2000 on SQL server 7.0 failed

5. Restoring backups of SQL6.5 into SQL 7.0

6. BACKUP/RESTORE in SQL 7.0

7. How to restore a SQL6.5 Backup into a SQL 7.0

8. Problems restoring an SQL 7.0 backup

9. Merge Replication Backup/Restore SQL 7.0

10. Restoring a backup to a different database using SQL 7.0

11. Backup SQL 7.0 database on NT server and restore on 2000 server

12. backup after restore of sql 7.0 database


 
Powered by phpBB® Forum Software