Sample plan: Microsoft® SQL Server 2008 Release 2 Cluster - Middleware patching

This sample plan automates patching of Microsoft® SQL Server 2008 Release 2 in a cluster. The plan is designed to automate Microsoft® SQL Server 2008 Release 2 patching for a two node cluster. The first step and last step in the plan are common to each of the nodes in the cluster. For these steps, you must target both nodes in the cluster. For steps 2 to 8, target the first node in the cluster, replacing the placeholder patching Fixlet with a Fixlet,Task, or Baseline to patch Microsoft® SQL Server. For steps 9 to 15, target the second node in the cluster, replacing the placeholder Fixlet with a patching Fixlet, Task or Baseline to patch the 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 plan automates patching of a two node Microsoft® SQL Server 2008 Release 2 cluster. The first step in the plan adds the nodes in the cluster to the Administrators group. The patching then proceeds for each node in the cluster, one at a time, with 7 steps for each node in the cluster. After you have copied the sample plan, you can modify it for a cluster with a different number of nodes. For example, if you wanted to modify the copied sample plan for a three node cluster, you would add another 7 steps, replicas of steps 2 to 8, for the third node in the cluster, and targeting the third node in the cluster when you are running the plan.

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 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 350 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 step 1, target both nodes in the cluster.
  7. For steps 2 to 8, 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.
  8. For steps 9 to 15, 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.
  9. For step 16, target both nodes. This step removes the cluster nodes from the Administrators group.
  10. Click OK to run the plan.