Export (0) Print
Expand All
Expand Minimize

Error 3154

SQL Server 2000

Error 3154

Severity Level 16
Message Text

The backup set holds a backup of a database other than the existing '%ls' database.


The backup set is a backup of a database with the same name as the database to which you are restoring. However, the database being restored was created by a different CREATE DATABASE statement than the database in the backup set. Even though the databases have the same name, they are in fact different databases.


Either overwrite the existing database by reissuing the RESTORE DATABASE command using the WITH REPLACE clause, or restore the backup set to a different database name. If you restore the backup set to a different database name, ensure that the files that will be created do not already exist and are not being used by another database. If you chose the wrong backup set to restore, select a backup of the existing database and restore it.

See Also

Backing Up and Restoring Databases



Troubleshooting Backing Up and Restoring

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft