By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.