Post reply

how to apply service packs on replication environment

  • January 9, 2014 at 9:07 am

    #302988

    Hi All,

    I have a question on how to apply service packs on a replicated environment.

    I have transactional replication configured on 2008. All are Enterprise Editions.

    Now, i want to apply the service pack upgrade, what should be the order of applying the service pack and what is the reason behind if one is choosen first over the other.

    Also, do I need to disable all the sql agent jobs or stop sql server agent so that replication activity can be performed on the servers?

    Are there any per-requistes to be taken care before apply the patch?

    Server-A:- Publication

    Server-B:- Distribution

    Server-C:- Subscriber

    Thanks in Advance.

  • January 9, 2014 at 9:18 am

    #1678839

    recommended way is

    distributor

    publisher

    subscriber

    disable replication jobs whilst applying to distributor

    replication will automatically be suspended when doing the publisher and subscriber

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

  • January 9, 2014 at 10:01 am

    #1678862

    Hi George,

    Thanks for the response. Could you explain why I need to pick up Distributor first and why not subscriber or publication?

  • January 9, 2014 at 10:06 am

    #1678867

    because the distributor does not contain the actual data. Distributor and publisher are often the same server as well.

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

  • January 9, 2014 at 11:51 am

    #1678918

    Thank you for the help.

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

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