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.
| Author |
Topic |
|
John Ludgate
Starting Member
2 Posts |
 Posted - 2009-06-30 : 18:21:00
|
| I am trying to restore a .bak file to a different volume. The volume which contained the database has failed and I have restarted the system with a new disk drive. SQL Server 2000 shows the database with (suspect) next to it since it cannot find the data which used to be there. I hoope that someone can tell me what is the correct/best way to restore the .bak database onto a different volume so that we can have it running again?Thank you for any help.john |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-06-30 : 20:07:06
|
| This may not be the best approach, but I would:1. Delete the existing database2. Create a new DB with the same name on the new volume3. Restore the .bak to the new database |
 |
|
|
John Ludgate
Starting Member
2 Posts |
Posted - 2009-07-02 : 07:25:56
|
| I would like to thank you Timmy for your reply. It was helpful to me. Because of other problems on the old server, I had to reinstall sql 2000 onto another server first and then follow your advice to a successful restore of the database. I did have to use the option feature of the restore to change the drive letter of where the restore was headed since the drive letters did not match on the new computer. |
|
|
|
|
|
|
restoring .bak file to different volume