Wednesday, March 28, 2012

Renaming a 2000 SQL Server

Hi
I have a client who has a SQL 2000 Server. He also has
another server that he would like to use as his SQL 2000
Server. I would like to take his current server, Wonder
and take it offline. Then take the new server, Menthal,
and rename it Wonder, then take Wonder and rename it
Menthal. The SQL server will still be named Wonder,
evnthough it is a completely different server. Is there
anything I need to consider when attempting this change?
thank you.These links should help:
http://vyaskn.tripod.com/administration_faq.htm#q5
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Bonnie" <bonnie.millar@.gems9.gov.bc.ca> wrote in message
news:2c0801c3fcaf$b967a680$a301280a@.phx.gbl...
Hi
I have a client who has a SQL 2000 Server. He also has
another server that he would like to use as his SQL 2000
Server. I would like to take his current server, Wonder
and take it offline. Then take the new server, Menthal,
and rename it Wonder, then take Wonder and rename it
Menthal. The SQL server will still be named Wonder,
evnthough it is a completely different server. Is there
anything I need to consider when attempting this change?
thank you.

No comments:

Post a Comment