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

**Artie** · Mar 20 '08, 06:05 PM

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:

How to move SQL Server from one computer to another? : Narayana Vyas Kondreddi's home page

http://vyaskn.tripod.com/moving_sql_server.htm

Welcome to the website of Narayana Vyas Kondreddi. This is a personal website, with some technical stuff which you will find useful. This site features some great SQL Server, Visual Basic, ASP resources. You will also find an FAQ section on SQL Server replication. You will also find a list of handy shortcut keys of some Microsoft products. Additional sections include: A code library which features VB programs, stored procedures; A page dedicated to SQL Server related books;

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