SQL Server Patching with Availability Groups

1

Looking for advice on patching SQL Servers with Availability Groups…

I think the fixlet flow would be

  1. Call a powershell or tsql to failover the AG and pass back a status
  2. Set up a relevance to check the status
  3. Perform the Patch(s)
  4. Call a powershell/tsql to failback the AG

I am new to fixlets so looking for any advice or templates I can follow.

Thanks!

2

Do you have BigFix Lifecycle? If so, there is a sample Server Automation plan that provides will handle this scenario.

1 Like
3

We do have the LifeCycle, do you happen to know the Server Automation #?

4

Look on the License Overview dashboard for the Server Automation site to see if it is enabled. And confirm that your Operator account has been given Read access to the site.

Note that Server Automation has its own Domain, apart from Systems Lifecycle.

5

We are also looking for a proper method for handling patching of clusters with SQL AlwaysOn / Availability groups.

We have Server Automation but we have no sample plans that mention availability groups. Are there any other requirements to enable this functionality?