Re-name Server

Question

Post reply

Re-name Server

shiv-356842

SSCarpal Tunnel

Points: 4310
More actions
October 5, 2012 at 5:02 am

#282625

Hi Team,
We are going to re-name the server name 'A' ,'B' on this server we have sql server 2008 R2 default instance and 3 named instance configured as DB Mirroring and Logshipping
My Question is
at the time of re-name the server Database level we will get any issues please let us know we doing this taks in PROD.
TX

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

Look at the following links

http://msdn2.microsoft.com/en-us/library/ms345235.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=83229&SiteID=1

saidapurs Hall of Fame Points: 3477 More actions · Answer 2

Hi,

Below sp will work for you..

'sp_dropserver' and 'sp_addserver'

Satish...

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

shiv-356842 (10/5/2012)
Hi Team,
We are going to re-name the server name 'A' ,'B' on this server we have sql server 2008 R2 default instance and 3 named instance configured as DB Mirroring and Logshipping
My Question is
at the time of re-name the server Database level we will get any issues please let us know we doing this taks in PROD.
TX

TBH renaming a SQL server that is part of a log shipping and database mirroring topology is not something i would recommend. For mirroring this will affect the endpoints, Log shipping will be affected by the name change too.

Save yourself a whole bunch of troubles and break the mirror and LS, rename the server and re apply the mirror and LS scenarios

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉