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