We help IT Professionals succeed at work.

upgrade from Windows server 2000 with sql server 2000 to Windows server 2003 Std with SQL server 2000  using the same name

RRCaldwell
RRCaldwell asked
on
Medium Priority
182 Views
Last Modified: 2012-05-07
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.
Test.
Go on to the next project.

Thanks,

Bob C



 
Comment
Watch Question

Senior Network Administrator
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I will be doing this tomorrow night.

Thanks,

Bob C
Gary DewrellSenior Network Administrator

Commented:
How did it go Bob?

Author

Commented:
It did work.  Sorry I had not gotten back to you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.