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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Easy Back up and restore

Author  Topic 

ells
Starting Member

25 Posts

Posted - 2008-07-03 : 10:27:52
Ok have an instance on one server and need to copy this to one other server. By right clicking on the instance it says size is 10238 MB.

Whats the easiest way to copy this from one server to another?

Would like to do this to move it to a mcahine disconnected from the network as well so a way of backing up to files and restoring would be fab too.

Easy way is good.

Thanks.
Ells

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-03 : 10:30:03
use DATABASE BACKUP & RESTORE
refer to Books Online
http://msdn.microsoft.com/en-us/library/ms175477.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -