?
Solved

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
4
Medium Priority
?
162 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



 
0
Comment
Question by:RRCaldwell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
Gary Dewrell earned 1500 total points
ID: 24825960
Yes that works fine. Just did it not long ago.
I was a little more paranoid. My steps were:
1. Stage new server off network with same name and IP address.
2.Restore backup of DB's to new server.
3. Test that SQL could mount the DBs
4. Got happy becuse it actually worked
5. Stopped sql on old box
6. Got fresh copy of DBs copied to new box.
7. Disconnected NIC on old box
8. Removed account from AD
9. Connected new box to netwrok with correct IP
10. Joined to domain
11. Reboot
12. Said short prayer.

Whew! Go on to next project.

Might have missed a few minor steps and definately a few prayers in that list. :)
0
 

Author Comment

by:RRCaldwell
ID: 24838983
I will be doing this tomorrow night.

Thanks,

Bob C
0
 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 24918095
How did it go Bob?
0
 

Author Closing Comment

by:RRCaldwell
ID: 31602165
It did work.  Sorry I had not gotten back to you.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question