How to fix SQL Server Error 3154: The backup set holds a backup of a database other than the existing database.

Fix/Solution:

Use WITH REPLACE while using the RESTORE command.

RESTORE DATABASE abc FROM DISK = 'C:\backup.bak' WITH REPLACE

In this example abc is one database,backup.bak is backup of abc.

3 comments:

mac morley said...
This comment has been removed by the author.
mac morley said...

u can easily fix sql server error 3154 by following this blog www.sqlrecoverysoftware.net/blog/sql-server-error-3154.html and let me know is this blog solved your query or not.

Henry Gill said...

I too faced the same error but following the blog http://en.mssqldatabaserepair.org/ I was able to resolve the issue in easy manner. You too must visit the blog.