469,592 Members | 2,032 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Moving SQL 2000 to a new machine by copy-paste !!

I have moved SQL 2000 to new hardware several times following various
'approved' procedures with success.
I have a customer who did the following and it seems to work (although very
minimal testing has been done):
1) SQL 2000 was installed to new machine from CD
2) stopped SQL services on new and old machine
3) COPIED \Program Files\Microsoft SQL Server and all subfolders (all dbs
including master, model, tempdb, user dbs, etc)
4) shut down old machine
5) renamed new machine in Windows to same name as old machine and rebooted
6) used sp_dropserver and sp_addserver to rename SQL to same as old machine

This is basically what this article says to do:
http://vyaskn.tripod.com/moving_sql_server.htm

I winced at the thought of this. Has anyone ever used this method?


Mar 20 '08 #1
0 1327

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Glen A Stromquist | last post: by
2 posts views Thread by bryja_klaudiusz[at]poczta[dot]fm | last post: by
6 posts views Thread by Woody Splawn | last post: by
15 posts views Thread by mcjason | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.