SQL-Server: The backup set holds a backup of a database other than the existing
sql-server
Solution
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'".
Problem
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?