Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
silas2
Yak Posting Veteran
65 Posts |
Posted - 2005-08-18 : 13:58:59
|
Can you restore a backup (bak) file to a different server? E.g. client gets server nicked, they have bak files, can I run a restore to my sql server? I can see the with MOVE option, but I can't see how to attach (to the new server) if the database wasn't detached (from the nicked server). |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-18 : 14:01:15
|
Yes you can with both RESTORE DATABASE or sp_attach_db/sp_attach_single_file_db. You use the WITH MOVE option of the RESTORE command if the paths to the MDF and/or LDF will be different from the original server.Tara |
|
|
|
|
|