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

All we need is an easy explanation of the problem, so here it is.

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.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

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.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

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

Leave a Reply