Sample plan: Microsoft SQL Server 2008 to 2012 Release 2 Cluster - OS patching

This sample automation plan provides a template for you to automate patching of clusters with Microsoft SQL Server installed on Windows 2008-2012 Release 2 operating systems. It contains a Fixlet to automatically reboot the targets endpoint. You can use this sample plan as a template if the patch Fixlet that you are including to patch the nodes in the cluster requires the endpoints to be restarted. The step that patches the operating systems runs all of the Baselines from a site. All sample plans are read-only. To use a sample plan, you must copy it, re-name it,.

About this task

Use this plan with the Pending Restart settings in the Server Automation application and configure the Pending Restart settings to Continue to next step. There are no parameters required to run this plan. For more information about patching Microsoft clusters, see Patching Microsoft Windows clusters. This sample plan uses the Bases from a site feature to patch the operating systems. For information about running Baselines from a site, see Running baselines from a site.

Complete the following steps to run the 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 142 and press Enter.
  4. Select the plan from the list of Automation Plans.
  5. Click Copy to copy the Automation Plan, enter a name, and then save the copy that you have just created.
  6. To run the copied Automation Plan, click Take Action. The following table shows the parameters and targets that you need to input for each step in the sample Automation Plan.
    Table 1. Plan steps and targets

    Step Description Parameters and targets
    Step 1 Pause Node (Windows 2008-2012) This step pauses the first node in the cluster that you want to patch. Target the system or systems for the first set of nodes that you are patching.
    Step 2 Move Groups from Node (Windows 2008-2012) This step moves groups from the node that you are pausing in step 1. Target the system or systems for the first set of nodes that you are pausing in step 1. You can select the Use same targets as option to quickly select the same targets you targeted for step 1.
    Step 3 Dynamically Run Baselines from a Site This step runs all Baselines from a site to patch the operating systems. Select the site that contains the Baselines for patching the operating system. Target the first set of nodes that you want to patch. You can select the Use same targets as option to quickly select the same targets you targeted for step 1.
    Step 4 Restart Endpoint and Wait for Restart to Complete This step restarts the computers that you patched in step 3. Target the system or systems for the first set of nodes that you are patching. You can select the Use same targets as option to quickly select the same targets you targeted for step 1.
    Step 5 Resume Node (Windows 2008-2012) This step resumes the first set of computers that you are patching. Target the system or systems for the first set of nodes that you are patching. You can select the Use same targets as option to quickly select the same targets you targeted for step 1.
    Step 6 Pause Node (Windows 2008-2012) This step pauses the second set of nodes that you are patching. Target the system or systems for the second set of nodes that you are patching.
    Step 7 Move Groups from Node (Windows 2008-2012) This step moves groups from the node that you paused in step 6. Target the system or systems for the second set of nodes that you are patching. You can select the Use same targets as option to quickly select the same targets you targeted for step 6.
    Step 8 Dynamically Run Baselines from a Site This step runs all Baselines from a site to patch the operating systems. Select the site that contains the Baselines for patching the operating system. Target the second set of nodes that you want to patch. You can select the Use same targets as option to quickly select the same targets you targeted for step 1.
    Step 9 Restart Endpoint and Wait for Restart to Complete This step restarts the computers patched in step 8. Target the system or systems for the second set of nodes that you are patching. You can select the Use same targets as option to quickly select the same targets you targeted for step 6.
    Step 10 Resume Node (Windows 2008-2012) This step resumes the second set of nodes patched in step 8. Target the system or systems for the second set of nodes that you are patching. You can select the Use same targets as option to quickly select the same targets you targeted for step 6.
  7. Click OK to run the Automation Plan.