Post reply

Log Shipping - primary server renamed

  • June 28, 2007 at 7:39 am

    #174209

    SQL 2005:  We have log shipping running.  The primary server ( box not instance )  is to be renamed.  Since the sql install is a default instance, sql should recognize the name change to the box upon reboot.  I  have the small script which changes the internal name so sql server will be all good.         Rather than recreate log shipping, I will need to update the primary server name in some tables on the standby server.    If anyone has gone through this I would like to see a list of updates needed.

    thanks,

    Randy

  • June 28, 2007 at 8:09 am

    #715862

    sounds interesting,ensure u change the originating_server_id column in the sysjobs system table...do revert with your results once u perform it successfully so that we will know the steps.....

    [font="Verdana"]- Deepak[/font]

  • June 28, 2007 at 8:54 am

    #715885

    SQL Server recognizes name changes without any restart but for you since you have log shipping configured you need to check if there are any issues if so you can change those records using some system procedure that will be there by default.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 29, 2007 at 6:43 am

    #716151

    I guess I'll just look at all of the log shipping table to see where the server name needs to be updated.  http://msdn2.microsoft.com/en-us/library/ms190355.aspx

  • July 2, 2007 at 11:57 am

    #716622

    Really? So you rename a machine and you won't restart it ?


    * Noel

  • July 2, 2007 at 12:16 pm

    #716629

    From: the person who started this thread

    We will restart the primary server after it is renamed.

    My plan is to first try updating the appropriate log shipping tables on both primary and secondary to reflect the new name of the primary.  If that doesn't work I'll delete log shipping and use the scripts I generated when log shipping was first set up ( with name changed as needed ) to see if I can get log shipping going again that way.   Otherwise it's drop log shipping and recreate from scratch ( 3 times, once for each database involved in log shipping )

Viewing 6 posts - 1 through 5 (of 5 total)

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