Export (0) Print
Expand All
Expand Minimize
2 out of 8 rated this helpful - Rate this topic

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.

Explanation

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.

Action

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

CREATE DATABASE

RESTORE

Troubleshooting Backing Up and Restoring

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.