System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database

 

familiar with this message?  one of my problem always face when restore the shaerpoint content DB from other farm with backup file. today i found out the solution at this blog : http://www.linglom.com/2009/07/08/solved-system-data-sqlclient-sqlerror-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-dbname-database/

*if you restore the path to different path of mdf and ldf, you need to change it

is great to keep it , so i will copy paste here for future reference.

before start restore the bak file, you need to create the new Database then restore the bak.

Problem

You have backup a database on SQL Server 2005. Then, you try to restore the backup file on an existing database and receive the error message below:

Restore failed for Server ‘SQL Server name‘. (Microsoft.SqlServer.Smo)
Additional information:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName‘ database. (Microsoft.SqlServer.Smo)

This error message indicates that you are going to restore a database on another database which are not the same database. For example, you have backup Northwind database and try to restore the backup to AdventureWorks database, the error will occur.

Solution

To solve the problem, you can use the overwrite the existing database option while you’re restoring.

1. On Restore Database, select Options tab on the left menu. Then, check Overwrite the existing database on Restore options.
   Note: This option will overwrite any existing data on the targeted database.
   
2. Try to restore the database, the problem should be gone now.
   

Note: you can also delete the targeted database before perform restore a database. This way also gives the result as same as the solution above.