INFORMATICS

The Best

patching SQL Server with Availability Group and Secondary Replica

Звезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активна
 

Make sure you have full backups of your databases.

On the primary replica node, change the failover mode to manual

Refresh the databases and check if MSSQL reports any errors

Apply fix - CU0x service pack Perform an update for all databases until all fixes are uploaded.

After uploading patches and restarting MSSQL, check if the cluster is in good condition. P

erform an update for the Primary server.

After uploading all patches, check if the cluster is in good condition.

If there are no errors, change the switching mode from manual to automatic.

 

Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups (sqlshack.com)

SQL SERVER - How to Apply Patch in AlwaysOn Availability Group Configuration? - SQL Authority with Pinal Dave

Search