upgrade from Windows server 2000 with sql server 2000 to Windows server 2003 Std with SQL server 2000 using the same name
Posted on 2009-07-10
I am replacing a server: I have an old windows 2000 server running sql server 2000. It is not a DC, no Exchange. I am replacing it with a windows 2003 server std running sql server 2000.
I have 100 PCs connecting to the databases using ODBC.
I want to end up with the replacement server having the same name and ip address as the old one. I want to have as little down time as possible.
I am hoping that once I get the new server on-line that the clients will see it and just work.
The server, database names, rights will be the same.
Is this going to work?
What is the best plan?
This is what I am planning:
After backing up and copying the databases off the old server.
Turn off the old server and delete it's computer account in the AD.
Name the new server to the same name as the old.
Join it to the domain.
Copy the database to the new server.
Attach the dabases with the same name.
Check the database rights.
Go on to the next project.