Monday, February 7, 2011

The backup set holds a backup of a database other than the existing

The below sql error usually comes while taking SQL Server backup. Error message is:
System.Data.SqlClient.SqlError; The backup set holds a backup of a database other than the existing.

Solution:
You can run the in the browser the following command

RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\BackupAdventureworks.bak'
WITH REPLACE

Or Go to options and check Overwrite the existing database from the database restore window.