September 13, 2002 at 6:56 am
We have a production server (say, computer name A, and SQL Server name A) that has been giving us blue screen problem the last 2 months. We now wanted to rebuild another server (computer name B and SQL Server name B)to the production environment. Once computer B built and tested, we'll take computer A off the network and rename computer B to computer name A and SQL Server name A to put it into production.
What is the procedure to rename servers? ( I read some doc in BOL about sp_addserver, sp_dropserver. But not too sure how it works.) Is renaming a fairly safe process without much problems in upsetting databases, logins, network permissions, registry settings etc? I am concerned that although everything has been tested perfectly in computer B, renaming it will upset the whole setup and invalidate all the tests.
September 13, 2002 at 8:04 am
If you look at the proc its a fairly simple update. Shouldnt affect any of the things you mentioned. If you move all your mdf's to the new server when you switch then you'd have no possible issues.
Andy
September 13, 2002 at 8:10 am
Renaming is a fairly simply process. I've gone through it before myself. If you're following the steps in BOL for SQL Server 2000, there is a bug in the docs. Here's the KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303774
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply