Home / server / Questions / 162327
Accepted
Malfist
Asked: 2010-07-21 10:21:44 +0800 CST

Restoring database from another server

  • 772

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?

sql-server

1 Answers

  1. Best Answer

    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.

    • 4