1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “The backup set holds a backup of a database other than the existing database” – SQL Server Error Message

“The backup set holds a backup of a database other than the existing database” – SQL Server Error Message

Summary

This Error Message Article explains the SQL Server error message “The backup set holds a backup of a database other than the existing database” and details how to fix the underlying problem that caused it to appear.

Explanation

You may get this message when restoring a database from a backup that was created from another server.  SQL may not automatically overwrite the existing database unless you specifically tell it to overwrite.

Solution

On the right pane of the Restore window in SQL Server Management Studio, select Options and check the ‘Overwrite the existing database (WITH REPLACE)’.

Additional Comments

Related Article:  KBA-01307-X3W8Y8 – SQL Restore Fails Due to Incorrect Restore Settings

Error Message First Appeared: Windows 7 and 8 running BACKTRACK v6 and 2012 with SQL Express 2012

Updated on August 15, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support