Sunday, February 17, 2008

MSSQL: The backup set holds a backup of a database other than the existing database.

When restoring a backup database that itself has a backup database, you will get this error:
"The backup set holds a backup of a database other than the existing '<DBName>' database."

All you need to do is to select the "Option" screen and make sure you have "overwrite existing database" selected.

No comments: