Wednesday, March 21, 2012

Moving SQL server to new hardware

I have a domain controller "ServerA". I am going to be replacing this
hardware with a new server - "ServerB". Currently "ServerA" runs SQL 2000
standard and has one instance "ServerA". I have a number of applications
etc, that use data on ServerA. When I bring Server B up, is there a way to
have the instance name to be ServerA and does this still change my
connection strings etc? I am just looking for a way to replace the server,
and not have to change all of my connection strings across the enterprise.
Both serverA and serverB are windows 2003 and both are SQL 2000.
Looking forward to your advice.See if this helps:
How to move SQL Server from one computer to another
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:eayAUbuuEHA.2632@.TK2MSFTNGP12.phx.gbl...
I have a domain controller "ServerA". I am going to be replacing this
hardware with a new server - "ServerB". Currently "ServerA" runs SQL 2000
standard and has one instance "ServerA". I have a number of applications
etc, that use data on ServerA. When I bring Server B up, is there a way to
have the instance name to be ServerA and does this still change my
connection strings etc? I am just looking for a way to replace the server,
and not have to change all of my connection strings across the enterprise.
Both serverA and serverB are windows 2003 and both are SQL 2000.
Looking forward to your advice.

No comments:

Post a Comment