Post reply

Installing Service pack on replicated DB

  • November 4, 2008 at 3:15 am

    #383295

    Hi all,

    Hope someone has had some experience with this.

    I currently have 3 out of 6 Subscribers running SP 3 and I would like to update to SP 4.

    Procedure I intend to follow:

    1. Stop Subscriber replication synchronisation.

    2. Apply SP 4 on Subscriber server.

    3. Start Replication synchronisation.

    Is the above adequate or would it be recommended to re-publish to these servers?

    Current Setup:

    SQL 2005 - Publisher Distributor

    SQL 2000 - Subscriber DB

    Running Contineous Merge replication Pushing from Publisher.

    Any advice is appreciated !

  • November 5, 2008 at 10:12 am

    #894394

    That should work fine. Your publisher/distributor is already on a higher version so you don't have to worry about them.

    You shouldn't have to re-publish when you are finished.

  • November 5, 2008 at 10:31 am

    #894416

    Cool, thanks for the feedback!

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

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