Installing an SQL Server patch package

This topic describes how to install a Microsoft SQL Server patch package.

To install an SQL Server patch package

1. From the Management Console main page, select Patching > Patch Repository in the Context Frame.
2. In the Patch Repository page, select a patch package and select Install from the list box for that row.

3. In the MS SQL Server Patch Install Candidates page, populate the following fields, and click Next.

   Note

   SQL Server 2008 provides improved flexibility for candidate selection when applying patches to clustered instances. Additionally, BMC Database Automation supports Microsoft failover cluster rolling update, which is the process of patching SQL Server 2008 clustered instances in series and failing over the active instance in the middle of the series. Selecting both cluster instances automatically triggers this function. http://support.microsoft.com/kb/958734 http://msdn.microsoft.com/en-us/library/ms191295.aspx

   You can view a list of the targets that were excluded from the installation candidates list, and the reason for the exclusion, by clicking Excluded Candidates.

4. In the Job Options page, specify any of the following Job options, and click Next.
5. In the Scheduling page, select when to run this job in the Job Execution field, and click Next.

6. If the Change Control page displays, populate the following fields, and click Next.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

7. In the Summary page, review the information.
   To make changes, do the following:
   1. Click Go to to return to the provisioning step that you want to edit.
   2. Make your changes.
   3. Click Save and Review to return to the Summary page.
8. Specify your verification preferences.
   • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

   • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

     Note

     The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

9. Click Execute Job or Schedule Job(depending on your selection in the Scheduling page).

   Note

   Databases that are in an Up state before the patch package installation process began are restarted after the installation is completed. Clustered SQL Server instances are required to be started before service packs and hot fixes are applied. When the patch package installation process is complete, the instance is left running.