In my last post, we defined the prerequisites needed for patching.  Before applying the patch, we need to make sure the variables are set and that we're dealing with a healthy AG.  With those out of the way, we're ready to build out the remaining tasks.  

• tasks/cleanup.yml
• tasks/failback.yml
  ...

Defining the prerequisites before you start patching is extremely important.  I'm not talking about making sure your Ansible control node is set up and testing access to your SQL Server AG replicas (very important as well, but a different subject).  

Nope, I'm talking about making sure that the exe...

In my previous post, we explored the concept of rolling updates for SQL Server Availability Groups and how Ansible can transform this complex process into a streamlined, repeatable operation. We discussed the benefits of automation and outlined a high-level strategy for implementing this approach.