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

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

Advertisement