How can I copy the DataBase from my Server at work to my laptop? I'm on the network at work, I just can't figure out how to copy it...
Please help! :)
Thanks,
Jacob
Look up detach database in Books On Line, sp_detach_db and sp_attach_db|||Do I need SQL Server 2005 (not express) to do this through the management studio?
I'm not going to mess with doing this myself, I want the software to do it.
|||
I don't have SSMS-E installed but right click on the database and see if you have a detach option, or an All tasks|Detach Option.
If you do, take it, once the file is detached just copy the foo.mdf and foo.ldf to the new server, then right click and select attach.
No comments:
Post a Comment