This is a follow up of the blog post I have posted on error 3154 few years ago. I have received quite a few emails that how we can fix the same error with the help of SQL Server Management Studio. In this blog post, I will explain how we can do the same with SSMS. Here is the error code:
Error 3154: The backup set holds a backup of a database other than the existing database.
You can fix that with the help of T-SQL with the following command.
RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\BackupAdventureworks.bak'
If you want to do the same with SSMS, you can follow the steps here:
Step 1: Create a database with your preferred name. (In our case AdventureWorks)
Step 2: Write click on the database and click on Tasks >> Restore >> Database...
Step 3: On the restore screen go to third selection of Options. Now select the checkbox "Overwrite the existing database (WITH REPLACE)"
Step 4: Click OK. It should successfully restore the database.
Note: When you restore a database WITH REPLACE it will overwrite the old database.
Relevant Blog Post:
Reference : Pinal Dave (http://blog.SQLAuthority.com)