Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to restore backup of SQL Server 7 to 2000

Author  Topic 

bridge
Yak Posting Veteran

93 Posts

Posted - 2005-05-05 : 02:12:22
I have backup of database which was in SQL Server 7. Now I want to restore it to SQL Server 2000. What I may do? When I restore it it gives me error

Error 3038: The filename '\db_1' is invalid as a backup device name. Reissue the BACKUP statement with a valid filename.
RESTORE FILELIST is terminating abnormally.

jamie
Aged Yak Warrior

542 Posts

Posted - 2005-05-09 : 08:55:06
use EM and try to restore from device. click Add and browse to the file db7name.BAK, then tick the box force restore over existing.
I do this daily and have no problems..
Go to Top of Page
   

- Advertisement -