Wednesday, September 9, 2009

Solution to: The backup set holds a backup of a database other than the existing database

SQL Error: Error 3154: The backup set holds a backup of a database other than the existing database.

Here is the solution:

RESTORE DATABASE <dbname>

FROM DISK = '<dbname.bak file path on local machine>' /*e.g. 'c:\dbname.bak' */
WITH REPLACE

2 comments: