Sample Plan: Microsoft SQL Server 2012 / 2014 Cluster - Middleware patching

This sample plan automates patching of Microsoft® SQL Server 2012 and Microsoft SQL Server 2014 clusters. The plan is designed to automate Microsoft SQL Server 2012 or Microsoft SQL Server 2014 patching for a two node cluster. The automation is executed in two phases, one for each node in the cluster. For steps 1 to 7, the first node in the cluster is patched. These steps are then replicated in steps 8 to 14 on the second node in the cluster. At all times during the patching process the cluster remains operational and available. For each phase in the automation, replace the placeholder steps, replacing them with a Fixlet, Task or Baseline to patch Microsoft SQL Server. All sample plans are read-only. To use a sample plan, you must copy it, re-name it, and then update the placeholder Fixlets with Fixlets, Tasks, or Baselines as per your requirements.

About this task

This sample demonstrates how you can automate patching of a two node Microsoft SQL Server 2012 or Microsoft SQL Server 2014 cluster. The patching process comprises two phases, one for each node. You can modify the copied plan for a cluster with a different number of nodes. For example, if you want the plan to automate patching for a three node cluster, you would add 7 more steps, replicas of steps 1 to 7 for the third node in the cluster.

Each phase in the patching process completes the following actions:
  • Prepatch step, moving all groups off the node and pausing the node
  • Make the node unavailable as owner for resources in the cluster
  • Resume the node
  • Patch Fixlets, Tasks, or Baselines - you must replace the placeholder as per your requirements
  • Restart the endpoints
  • Make node available as owner of resources in the cluster
  • Post-patching cleanup step

Complete the following steps to use this sample Automation Plan.

Procedure

  1. Open the Server Automation domain.
  2. From the navigation tree in the Domain Panel, click Automation Plans.
  3. In the Automation Plans dashboard, enter 351 for the plan ID to search for the sample plan and press Enter.
  4. Select the sample plan from the list of Automation Plans. Click Copy to copy the Automation Plan, enter a name and then save the copy that you have just created.
  5. To run the copied Automation Plan, click Take Action.
  6. For steps 1 to 7, target the first node in the cluster. You can use the Use same target as step option as necessary. You must replace the placeholder Fixlet with a Fixlet, Task or Baseline that you want to use to patch Microsoft SQL Server.
  7. For steps 8 to 14, target the second node in the cluster. You can use the Use same target as step option as necessary. You must also replace the placeholder Fixlet with a Fixlet, Task or Baseline that you want to use to patch Microsoft SQL Server.