Patching or Updating Availability Group with SQL Server Failover Cluster Instance Part 1 - DBA Tutorial

In this video you will learn following:

1- Patching or updating Availability Group replicas when SQL Server is installed in Cluster mode
2- How to failover SQL Server instance from one node to another node in SQL Server?
3- How to apply Patch on secondary replica when Availability Group is setup on the server?
4- How to check if availability group is working fine after patching on secondary replica?
5- How to resume database movement in SQL Server Availability group?


General process steps


1-     Remove Automatic Failover on all synchronous-commit secondary replicas
2-     Upgrade all remote and secondary nodes
3-     Manually failover AG to updated secondary replica
4-     Make sure everything is working fine before you start primary replica
5-     Update primary replica
6-     Manually failback AG to primary replica
7-     Make sure everything is working fine
8-     Configure automatic failover, synchronous commit as it was before upgrade/patching

Patching/Updating AG with one Remote Secondary


1-     Change Synchronous commit to Asynchronous commit (If Any)
2-     Change Automatic Failover to Manual Failover
3-     Make sure AG Group is on Primary Replica
4-     Upgrade Secondary Replica (Remote Secondary)
5-     Failover over to secondary Replica (Remote)
6-     Upgrade Primary Replica
7-     Failback AG to Primary Replica
8-     Set Synchronous commit and Automatic Failover as it was before upgrade

Patching/Updating AG with Failover Cluster Instance





CLT01
CLT02
AG

NY01
NY02

1-     Failover SQL Server instance/instances to CLT01
2-     Upgrade CLT02
3-     Failover SQL Server instances on CLT02
4-     Make sure All works fine
5-     Repeat the process for NY01 and NY02
6-     Manual failover AG to NY instances from CLT

7-     Make sure all works fine.



Patching or Updating Availability Group with SQL Server Failover Cluster Instance Part 1 - DBA Tutorial

2 comments:

  1. Breitling replica watches is one of the world's most respected Swiss horologists. replica breitling Founded in 1884 in Saint-Imier, the brand cemented its reputation as an aviation specialist, but is now an authority in diving and chronograph categories, too. Specialist watchmaking All COSC certified chronometers.

    ReplyDelete
  2. Hello Team,
    Can you help me with documents showed in the video please..?

    ReplyDelete