Post reply

Changing distributor server name

  • September 7, 2007 at 12:44 pm

    #92732

    My company is going to change all server names. Is there some problem with the SQL Servers that are Subscribers? Look like replication works with hostnames instead IP. How can I handle this problem with less pain?

    Thanks.

    Best regards,

    Leomar

  • September 7, 2007 at 3:23 pm

    #732277

    I have not found an easy way out of that one

    Sorry for the bad news.


    * Noel

  • September 8, 2007 at 9:53 am

    #732331

    So it's better not to change the server names???

  • September 11, 2007 at 2:48 am

    #732701

    Hi,

    Are they pull or push subscriptions?

    In general you can change quite easily the publisher/distributor server name if it's the same. Use sp_addserver and sp_dropserver and modify the distribution agent jobs. In addition, you should check the distribution database if the old name disappeared. If not, you should change it as well.

    Basically, it's a lot of hacking, so test it before production use. I have no test server at hand to give you a step-by-step instructions, if you need one, I might do it

     

    -- Erik http://blog.rollback.hu

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

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