I am trying to restore a SQL Server backup file for my database, but it is throwing an error as follow:
The backup set holds a backup of a database other than the existing
My database in SQL Server 2008 and the backup file is in 2005.
What can be the problem?
I too came across this issue.
Solution :
- Don’t create an empty database and restore the
.bak file on to it.
- Use ‘Restore Database’ option accessible by right clicking the “Databases” branch of the SQL Server Management Studio and provide the database name while
providing the source to restore.
- Also change the file names at “Files” if the other database still exists. Otherwise you get “The file ‘…’ cannot be overwritten. It is being used by database ‘yourFirstDb'”.
