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 |
|
neil
Starting Member
29 Posts |
 Posted - 2004-01-07 : 05:35:00
|
| I have a backup file from a server that has had a hardware failure and I want to restore the database from fresh.When I try to restore the database I get the following error message:'The backup set holds a backup of a database other than the existing 'db' database.RESTORE DATABASE is terminating abnormally'Any suggestions ? |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-01-07 : 10:48:46
|
| Run RESTORE HEADERONLY to get a listing of what is in the backup file. Find the file number of the database you want to restore. Then plug that numbe into your rstore command using the FILE=XX in the with clause. |
 |
|
|
|
|
|
backup restore failed