0

we have SQL server HA+DR solution in production built using DB mirroring combined with Transactional Replication with distributor and subscriber on the same remote DR SQL server instance. on researching how to patch this topology with Cumulative updates, the only documentation from Microsoft assumes if Distibutor exists on a separate SQL server than subscriber, referencing the same document if I had to perform rolling updates on the SQL instances, does the below order make sense? any guidance is appreciated.

  1. The mirror.
  2. The witness.
  3. The distributor/The subscriber(s).
  4. The principal/publisher.

P.S. the setup only exists in production, no way to test it out

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

Improve this question

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.