Error Message in SQL Server 2005: Restore failed for Server
Error Message in SQL Server 2005: Restore failed for Server 'xxx'. The backup set holds a backup of a database other than the existing database
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server 'xxx'.
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'xxx' database. (Microsoft.SqlServer.Smo)
Solution
Try clicking on Options on the left hand
side and then Overwrite the existing
database.
