Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.