Error 3154 - The backup set holds a backup of a database other than the existing database.

Hi all,

While Restoring Database on SQL Server Management Studio, some of us encounter an error i.e
Error 3154- "The backup set holds a backup of a database other than the existing database".

Resolution for the error

After selecting the database backup, goto option Tab from the Left Hand Side Menu and click on First Restore Option i.e Overwrite the existing database(WITH REPLACE) as shown in screen below.

* Make sure that there is no database file exist at the path mentioned in RESTORE the database file as section with same file name otherwise it will replace those files.

For Reading How to Restore a database from scratch in SQL Server Managment Studio, read article here.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/