Menu

Want to work with us? We're on the lookout for a talented Digital Project Manager.

We're hiring

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

Web Bureau


10 November 2010 by Web Bureau

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

Solution is very simple and not as difficult as he was thinking. He was trying to restore the database on another existing active database.

Fix/WorkAround/Solution:

1) Use WITH REPLACE while using the RESTORE command.

2) Delete the older database which is conflicting and restore again using RESTORE command.

3) Example :

RESTORE DATABASE AdventureWorks
    FROM DISK = 'C:\BackupAdventureworks.bak'
            WITH REPLACE
 
If this doesnt work then you may need to do one of the following:
 
1.  open up SQL Server Configuration Manager (I am using SQL Server 2005)

2.  right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)

3.  Choose Properties

4.   in the Logon tab - click the built in account radio button and choose 'Local system' from the drop down.

 

FROM DISK = 'd:\myfolder\TEST_FullBackup_20090823_2200.bak'
WITH REPLACE

OR

RESTORE DATABASE db_Test
FROM DISK = 'C:\Documents\db_Test_FullBackup_20090624_1737.bak'
WITH REPLACE

Grow your businessStart a project with us today.