Hi,
I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks
Hi,
You can backup/restore database or your detach/attach database.
Use sp_detach_db procedure and sp_attach_db procedure to achieve this.
For more information, check
http://msdn2.microsoft.com/en-us/library/ms188031.aspx
http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
