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

Thanks for Visit Here

Comments

Post a Comment