Back

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

Problem:

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.

Back


Make a Comment on this Article

Your Name:
Comment: