The backup set holds a backup of a database other than the existing ‘database_name’ database.

 

ERROR MESSAGE:

“System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘database_name’ database. (Microsoft.SqlServer.Smo)”

EXPLANATION:

If you already have a database with the same name as the database that you want to restore, and you have a database that is different from the database you want to restore, you will get this error.

SOLUTION:

For example, you have a database named “qw” in SQL Server Instance. You also have a backup file (aa.bak) of the database “aa”. If you try to restore this backup file by using the “qw” database name in your SQL Server Instance, you will get this error. Because they are two different databases.

Therefore, for the backup of the “aa” database you are trying to restore, either use the name “aa” as the database name, or use a database name that does not exist in the SQL Server Instance that you are currently working on.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

Your email address will not be published. Required fields are marked *