FIXED MSSQL Error 3154 – The backup set holds a backup of a database other than the existing database

By RahulAugust 15, 20161 Min ReadUpdated:October 15, 2016

Using SQL Query Window:

Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup.

USE MASTER
GO

RESTORE DATABASE  MyDB
FROM DISK = 'C:\Backups\MyDB_15082016.bak'
WITH REPLACE
GO