restoring a SQL 7.0 database under SQL 2000

[bdina]

I have a SQL 7.0 database that was backed up on a system that was sent to me to be restored on a SQL 2000 instance. How can I accomplish this, so far I have tried to attach the database and that did not work, I aslo have gone into the enterprise manager and tried to restore from a device, and no success either, it appears as though it is complaining that I can not restore to the same directory structure as on the old server, but I am unsure, this is the first time I have worked with moving a database, and am new to MS SQL as well with only a few months experience of administration.

thanks,
bryan

 

[SonOfEmidec1100]

You are nearly there.

Dump to dump device on sql7 server
Create a dump device (same name) on the sql2000
Copy the dump file devicename.bak to sql2000 server backup folder
Restore from this dump device on the sql2000
After selecting the device but before clicking the second ok (to start the restore) goto to the options tab and overtype the move to physical file name path to the appropriate data folder. If the database already exists also select force restore over existing database.

Hope this helps.

 

[ClaireHCM]

This might happend when the machine where you/others took backup is having some particular drives which doesnt exist on the machine where you are going to restore it.
Say I created a backup device in server A ,path = 'B:\myBackup.bak' and I named the backup device as 'Bakup1'
If I directly execute Restore database dbname from backup_device,of course it wont succeed.Because I dont have B drive in serverB
You can check for restore syntax with move statement.
ex.
restore database dbname from backup device
with replace,
move 'data_logicalname' to 'newpath',
move 'log_logicalname' to 'newpath'

Hope this helps!

 

[hencyt]

Can the same steps be done to restore a SQL 6.5 db to 2000?

Are they compatible?


Thanks,
Sunny