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.
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.