Solved

Replace 2000 server running SQL 2000 with new 2003 standard running SQL 2005. These are NOT Domain Controllers

Posted on 2006-06-22
7
189 Views
Last Modified: 2010-04-18
Replacing old Dell Poweredge, Windows 2000 server running SQL 2000  with new Dell Poweredge, Windows 2003 standard running SQL 2005  Need to use the same name and ip these are Not Domain Controllers. These are also running IIS, but will be moving that to a seperate server next week. What's the best way to deploy this.

Thank You,

0
Comment
Question by:traut01
  • 4
  • 3
7 Comments
 
LVL 21

Expert Comment

by:mcsween
Comment Utility
1. Build 2003 server and install SQL 2005 and any other apps (e.g. virus scanner, inventory apps, Dell Openmanager, etc...)
2. Change the IP of the W2k SQL server so clients don't connect and change the data while you are migrating it.
3. Give the 2003 server a different IP as well (we don't want users connecting to this server untill the data is fully migrated)
4. Do a full backup of the databases on the 2000 server and restore them to the 2003 server.
5. Ensure all Jobs, Stored Procedures, Users are moved and setup correctly on the new server.
6. Connect to the databases with every application that uses this server and test key functions (if this is a mission critical app you should test all funcitons)
7. Change the IP of the 2003 server to match the original IP of the 2000 server and away you go!
8. Don't forget to setup the backup on your new server
0
 

Author Comment

by:traut01
Comment Utility
How would you go about a name change I want the new 2003 server to have the same name of the original old 2000 server.
0
 
LVL 21

Expert Comment

by:mcsween
Comment Utility
Well you have 2 options.

1. At step 7 change the name of the 2003 server to match the name of the 2000 server (take 2000 server offline permanantly or change it's name first)
2. Allow the 2003 server to have a new name and create an alias in DNS with the 2000 server's name and point it at the new name of the 2003 server.

My suggestion is to do this in DNS rather than changing the server's name.  I've run into issues in the past when I build a new server and name it the same as an old server.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:traut01
Comment Utility
I'm increasing the points, I need to make sure I don't forget anything.
 
New Server has all software installed and ready to go. have not moved data yet. can't take old server offline untill after hours. I will backup SQL database to a USB drive, and plug it into the new server and use the restore feature pointing to the USB drive for restoring. maybe there's a better way of doing this my SQL file is 1.5 gig.

1) Old Server 2000  name is Let's say ( prodution.local ip= 10.11.0.230) connected to domain PRESS

2) New Server 2003 name is 1212superior and is still in a workgroup. IP address is whatever the dhcp server sent it will be changing this to staic anyways.

3)Do I have to first disjoin the domain on old server (production)  and put it into a workgroup before shutting it down? or do I connect the new server 2003 into the domain with the current name 1212superior and dynamic ip.

Thanks

0
 
LVL 21

Expert Comment

by:mcsween
Comment Utility
I would get all the data off the old server (backup to USB Key or Network Share), change it's name, disjoin it from the domain, and change it's IP before shutting it down.  (This way if someone accidentaly turns it back on you won't create a conflict)

Then I would change the new server to 10.11.0.230 and change it's name to the old server's name.  Restart the box and join it to the domain.

You will probably want to have both servers online so you can easily check to make sure all your stored procedures, jobs, databases, indexes, etc... were properly moved to the new server.  The key here is to change the IP and name of the old server before backing up the data.  This is what will prevent users from connecting and modifying the data after you backed it up.  You could take it offline but then you won't be able to connect to it yourself with Enterprise Manager.
0
 

Author Comment

by:traut01
Comment Utility
Got it:

Last question.

I will be the only one connecting to the servers, it's going to be done tommorrow so I have all weekend incase I run into problems. This server is also running IIS untill next week when I bring up a new server dedicated to web services. So I don't beleive I can have both servrers online at the same time. I guess I can turn off IIS on old server before bring new server online.

1) If I can't get it working can I alway reverse what we did above, or would that cause problems?

Thank You for your expertise.

No more questions.

best

Mike


0
 
LVL 21

Accepted Solution

by:
mcsween earned 450 total points
Comment Utility
If something goes wrong:

Name the 2003 server something like brokenserver, set it to DHCP, and disjoin it from AD.
Name the 2000 server the same as it was and give it the original static IP info then rejoin it to AD.
Everything will be running like it was before you shut it down.

As far as IIS goes it depends on how users are accessing it.  If they are using an alias to access IIS then you are all set.  Take the 2000 box, name it 2000IISServer or something like that, give it a NEW static IP and change the pointer on your alias to look at the new server.

If they aren't using an Alias you have to look at how you plan on migrating it to it's own box later.  Hopefully you give them a favorite through a GPO or something like that which will be easy to change.

If you aren't using an Alias I highly suggest it.  When you do it like that you can change the IP/Name of the server at a whim (or even move IIS to another box) and all you have to do to get the users there is to change where the alias is pointing.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Join & Write a Comment

Suggested Solutions

Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now