How to keep ip and domain name after moving the harddrive to another machine

I have 2 databases running on one sql server 2000, this server is old and need to be changed. I want to move the harddrive to a similiar newer server. I am wondering if the new machine has same ip and domain name after moving the harddrive to new machine. Since there are some appliations in the networking are calling two databases on this machine via ip and domain name like d1.test.abcd.com? how to approach?  is there any risk I lose applications?
blue_wirelessAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AncientFribCommented:
if this new server has nearly identical hardware then possibly yes.  If the boot process encounters difficulties while identifying new hardware than you may run in to a number of problems.

But bottom line is if the hardware is identical then technically you can swap hard drives and the machine will be as if it was never affected.
0
MikealclCommented:
Just move the databases and bind the ip to the new server.  Why physically move the hard drive??


0
blue_wirelessAuthor Commented:
moving database only will result in different domain name, and there are may be some other unknown settings, files and applications on old server. I don't have all documents about old server. So I think physically  moving hard drive is the simplest way.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MikealclCommented:
Its sql.  The client machines won't know the difference if you move the data, and bind the ip.
All you will have to check is your stored procedures etc.

0
easyDKCommented:
Try cloning that harddrive...
0
blue_wirelessAuthor Commented:
If all application query via IP in connection string / hard codes, that works. but some applications running on other machine query from this machine via domain name like "server=t1.old.machine.com". so I have to keep both domain name and IP.

why do I need to check store procedure? I am confused. As long as domain name and IP are same, other appliations on other machine query the same store procedure.
0
blue_wirelessAuthor Commented:
is cloning, say ghost keep the harddrive same ip and domain name?
0
MikealclCommented:
What do you think the computer name is?  It's nothing but a DNS record, or netbios name.

Just move the database, bind the IP, and make sure the DNS record still exists.
If your really paranoid use the hosts file in c:\windows\system32\drivers\etc to make the netbios name resolve to the right ip address.

I have never had to physically move a hard drive to migrate an SQL server.  That's really overkill.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AncientFribCommented:
Blue,

To answer your question - Yes cloning with Ghost will keep the same IP etc.  Mikealcl makes some good points though, this approach can be more painstaking than anything.  As I said, if the hardware is not identical, you are likely to have issues.

Although when I have ghosted a harddrive in the past for a backup machine with identical hardware it was a breeze overall.  So when it works, it works well, when it doesn't it is a real headache.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.