Software to help automate windows os patching with SQL Server high availability/failover clusters

The question:

is there a third party tool or a way to automate installing windows updates on windows clusters with sql server high availability groups installed? right now we have a manual process of installing then failing over etc.

The Solutions:

Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.

Method 1

There is not a tool that offers an out of box solution. However, there are many orchestration tools you can utilize to build your own automation solution. A few that come to mind are System Center Orchestrator or Ansible. Not to say those are the only tools, or the best tools. In the orchestration solutions you can build out a multi step playbook. Steps can include, checking if a replica is primary, pushing patches, failing replicas over, and rebooting servers. When or if each step executes could be tied to the outcome of the step before it.

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Comment