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
194 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
[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
  • 4
  • 3
7 Comments
 
LVL 22

Expert Comment

by:mcsween
ID: 16968837
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
ID: 16969430
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 22

Expert Comment

by:mcsween
ID: 16969929
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:traut01
ID: 16971005
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 22

Expert Comment

by:mcsween
ID: 16971048
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
ID: 16971323
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 22

Accepted Solution

by:
mcsween earned 450 total points
ID: 16972207
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Auslogics BoostSpeed 9 software 5 97
Can’t delete a file 14 233
Auto Login Script 3 82
the workstation driver is not installed 2003 3 75
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 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