Tuesday, 22 March 2011

SQL: The backup set holds a backup of a database other than existing database - SQL Server "2008

Cannot restore database using .bak file. It is showing an error message: The backup set holds a backup of a database other than existing database - SQL Server "2008. 

1. Select the Backup file to restore from the following window - Look at the left hand side you will see General Tab is selected



2. Click on the Option tab on the left hand side of the same window and Select: Overwrite the existing database

No comments:

Post a Comment