469,607 Members | 1,925 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,607 developers. It's quick & easy.

Moving from one server to another

Hi all,

I have been given the task of moving an sql database from one server
to another. These servers are not on the same network. I know I can
detach the database, copy it to a new location, then FTP it to the new
server and re-attach it.

My question is, is this the best way to do this? Or is there another
way? I have access to both servers through Enterprise Manager.

TIA
Jul 20 '05 #1
1 2362
GuyInTn (ch*********@NOSPAMreardenweb.com) writes:
I have been given the task of moving an sql database from one server
to another. These servers are not on the same network. I know I can
detach the database, copy it to a new location, then FTP it to the new
server and re-attach it.

My question is, is this the best way to do this? Or is there another
way? I have access to both servers through Enterprise Manager.


An alternative is to take backups and move those instead.

This article may be of interest:
http://support.microsoft.com/default...b;EN-US;224071.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Stephen Ghelerter | last post: by
1 post views Thread by barbara | last post: by
5 posts views Thread by Kay | last post: by
6 posts views Thread by Woody Splawn | last post: by
8 posts views Thread by rick | last post: by
1 post views Thread by gar598 | last post: by
15 posts views Thread by mcjason | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.