Sunday, February 26, 2012

Error 3154: The backup set holds a backup of a database other than the existing 'xx' datab

HELP!

This is happening with a restore to SS 2005 from a SS2000 backup. This article says to use the 'WITH REPLACE' clause. The SS2005 management studio does not seem to allow this via the GUI.

http://msdn2.microsoft.com/en-us/library/aa238217(sql.80).aspx

Did you use the overwrite flag in the GUI if the database already existed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||True and you can use the Query Editior to restore the same using RESTORE DATABASE .... WITH REPLACE, as referred in BOL it is easy.

No comments:

Post a Comment