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.