Patching a SQL Failover Cluster

When patching a SQL Failover Cluster with beekeeper, all the headaches are gone.  Verifying cluster health is just the first step in beekeeper‘s pre-patching validations.

prepatchcluster

Once the cluster has passed the health checks, the first node is tested and when it passes, patching would begin.

prepatchnode

Putting the first node into maintenance mode, beekeeper calls the SCCM client to install patches.

clusternodemainte

After apply software updates, beekeeper removes the first node from maintenance mode and then moves on to the next node in the cluster.

clusterdone

The SQL Failover Cluster has been patched, and the databases stayed online.  Only a single node was patched at a given time to make sure availability is not interrupted.

Using beekeeper to patch your systems saves the time operations personnel had to manual patch and verify success.

cldash

Get a trial copy of beekeeper today!!!

Leave a Reply