Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a backup that is from FS\SQLExpress. It was taken using the SQL Database backup tool in sql server management studio.

If I try to "restore" my database on THESTUDIO\SQLExpress with it's backup it tells me that it's for the wrong server. How can I make it accept it?

share|improve this question
Are they both SQL 2005/2008? What's the exact error message? – Jeremy Smyth Jul 20 '10 at 18:36
Both are SQL 2008, the exact error is 'System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'RentalEase' database. (Microsoft.SqlServer.Smo)' – Malfist Jul 20 '10 at 18:39
up vote 4 down vote accepted

You'll need to select the "Overwrite the existing database" option in the Options page in the Restore dialog. SQL Server doesn't like restoring over a different database without barking at you!

If you're using script, it's the WITH REPLACE option.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.