Steps to apply patches in Always on availability group replica servers

How do apply patch in always on availability group replica servers?

1. Make sure to connect the instances using 'Multisubnetfailover=TRUE' as this required to perform failover.

2.perform the patch apply in the secondary server replica .

3.Reboot the secondary server replica and perform health check .

4.Ensure databases are in synchronising mode in the secondary server replica .

-- select * from sys. Dm_hadr_database_replica_states.

Just check the synchronisation_state_desc and synchronisation_health_desc  column value for health values.

5.If Always on is configured in Asynchronous mode , then make sure to change it to Synchronous mode to avoid data loss.( Revert back to asynchronous mode once all steps for patch completed in both servers).

Alter  availability group group_name
Modify replica on 'server name '


({ availability _mode =synchronous_commit|asynchronous_commit})

6.Failover the Always on group to the Secondary server replica.

Use master
Alter availability group availability _group Failover

7.Ensure databases are in synchronised mode , if no , execute the following script for all availability group databases .

Use master
Alter database database_name
Set HADR resume

8.Apply the patch in the old primary server(Current secondary replica)

9.Reboot the old primary server and perform health check .

10.Failover from old secondary server to old primary server(production)

Execute below script

Use master
Alter availability group availability _group Failover

11.Perform health check .

To verify everything in place , view the dashboard of The availability group in sql server management studio.

Make sure New patch got applied in both servers successfully .


Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)