Azrure Update Manager - how do you manage SQL cluster / failover?

Question

Hello Microsoft Q&A Community,

I wondered if there was something obvious I was missing - but how is anyone handling SQL clusters when patching with Azure Update Manager?

Ideally it would failover from node01 to node02, patch node1 then reverse it and patch node02.

I've managed something similar with the old style Automation Account Update Manager - but wonder how others are approaching this with Azure Update Manager.

Thanks!

Answer 1

@Eccup Reservoir - Thanks for reaching out to us.

When patching SQL Server clusters with Azure Update Manager, you can use the cluster-aware updating (CAU) feature to automate the patching process.

To use CAU with Azure Update Manager, you need to create a CAU cluster role and configure it to use Azure Update Manager as the patch source. You can then use the CAU wizard to automate the patching process for your SQL Server cluster.

Here are the high-level steps to configure CAU with Azure Update Manager:

1. Create a CAU cluster role in Failover Cluster Manager.
2. Configure the CAU cluster role to use Azure Update Manager as the patch source.
3. Run the CAU wizard to automate the patching process for your SQL Server cluster.

For more detailed instructions on how to configure CAU with Azure Update Manager, you can refer to the Microsoft documentation on Automate patching for SQL Server failover clusters with Azure Update Management.

Hope this helps. and please feel free to reach out if you have any further questions.

---

If the above response was helpful, please feel free to "Accept as Answer" and click "Yes" so it can be beneficial to the community.