Applying Cumulative Updates with Transactional Replication

  • Apologies if this has come up before. I've searched for a similar question but couldn't find one.

    I have a SQL 2017 instance that is replicated to another 2017 instance using transactional replication. The distributor is on the same instance as the subscriber.

    From what I can gather here Microsoft recommends upgrading the subscriber/distributor instance first, but they also state that this is for ย an environment where a SQL Server is configured to participate in both database mirroring and transactional replication.

    https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/replication/install-service-packs-hotfixes

    I don't have mirroring configured, only transactional replication and I can't find specific instructions for my scenario. Is anyone able to offer some advice please?

    This is a high-class Bureau-de-Change.

  • Anybody?

    Is my scenario really that niche?

    This is a high-class Bureau-de-Change.

  • Just patch it however best suits the environment, replication will just carry on from where it was stopped due to the service shutdowns, there's nothing special you need to worry about, except making sure the log reader and distribution agents start up again

  • Thanks, Ant. I appreciate your certainty ๐Ÿ™‚

    This is a high-class Bureau-de-Change.

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

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