SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS

Step 1: Create a database with your preferred name. 

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.