Rolling back a previously applied SQL Server patch package - Documentation for BMC Database Automation 8.9

Patch Candidate Field

Description

Type a valid domain administrator account domain, user name, and password in the Remote Account Domain, Remote Account Username, and Remote Account Password fields, respectively.

Note

This field is enabled only if you select a SQL Server Instance on a WSFC node. If you are patching standalone SQL Server Instances on non-clustered nodes, BDA will not prompt you for credentials to a domain administrator account.   

Template

Displays the default BDA template selected from the Default Template field in the Edit Existing Package wizard. Optionally, you can select a template for this operation. See Managing templates for SQL Server. If you select a template, you can click Skip Ahead to advance directly to the next step that requires input. An information message appears in the step, in green type, listing the fields that require entries before advancing to the next step.

Select this check box to use the ALLINSTANCES parameter when running the SQL Server patch installer to apply/rollback the patch to all applicable instances of SQL Server on a given node rather than apply/rollback a patch to each instance individually. For more information about this parameter, see .

Important: It is required to have more than one candidate instance for a given node and you must select all the candidate instances on that node for BDA to use ALLINSTANCES to apply a patch to the instances on a node. BDA will not proceed unless this option is disabled. The pre and post patching scripts in this patch package still run individually for each instance at the appropriate time.

This option is available only to users having the "SQL Server Patch with /ALLINSTANCES" capability, see Capabilities tables 1.

Instances

Select the instances for which you want to roll back this patch package. The candidates for this patch package are determined by the patch version number defined when you created patch package.

Note: The candidates list does not get refreshed automatically. Click the Reload Candidates button to refresh the list.