472,119 Members | 1,688 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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:

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

Mar 20 '08 #1
0 1373

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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.