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

Posted by Sheonarayan under Error and Solution on 7/5/2014 | Points: 10 | Views : 1025 | Status : [Administrator] | Replies : 0

Problem

I was getting "System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing '' database." while restoring database from .bak file to the existing database.

Solution

Go to the Options tab of the Restore Database dialogue box and check "Overwrite the existing database (WITH REPLACE)" checkbox and try to restore again.

It should work.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com



Responses

(No response found.)

Login to post response