Microsoft SQL Server Classification Wizard

Ops Center Protector Microsoft SQL Application Guide

Version
7.9.x
Audience
anonymous
Part Number
MK-99PRT009-07

This wizard is launched when a new Microsoft SQL Server Database classification is added to the policy.

The Microsoft SQL Server Database classification conveniently specifies which should be included in a backup. Refer to About Microsoft SQL Server Policy Classifications for details on how this classification works.

Figure. Microsoft SQL Server Wizard - Specify Microsoft SQL Server classification attributes
Control Description
Node Select the Microsoft SQL Server node you want to protect with this classification.
Instance Select the SQL Server instance, hosting the databases you want to protect. This control is not available when an SQL Server Availability Group Node is selected.
Note: Instance is visible only in case of Cluster or Standalone Nodes.
User List the user which will be used to protect the instance. Editing the credentials will open the Microsoft SQL Server Instance Credentials Dialog SQL Server Instance Credentials Dialog.
Refresh Instances Refreshes the instances and Databases in the Node.
Note: Refresh Instance button is visible only in case of Cluster or Standalone Nodes.
Included Items Lists the databases which will be included in the backup.
Add Opens the Microsoft SQL Server Database Selection Wizard, which allows databases to be added to the Included Items list above.
Excluded Items Lists the databases that will be excluded from the backup policy.
Add Opens the Microsoft SQL Server Database Selection Wizard which allows databases to be added to the Excluded Items list above.
Preview Selection Opens the Microsoft SQL Server Classification Wizard, that will preview which databases will be included if the classification is applied to a selected Microsoft SQL node.
Backup Mode
Select which backup type is desired for the selected databases:
  • Full backup

    Create a point in time copy of the complete database.
  • Copy Only

    Create a point in time copy of the complete database. Does not affect sequencing of differential backups or transaction logs.
Replica Backup Preference

(Availability Group only)

Selected Replica

Select a specific replica (instance) as a source for the backup, irrespective if it is currently acting as a primary or a secondary replica. This option ensures that backups are always created on the same storage.

Primary

The primary replica at the time of the backup will be used to protect the databases of the availability group. Ensure that all possible storage arrays are configured on the data flow, as the location of the primary replica may change over time.

SQL Server preference

The SQL Server's Availability Group preference will be honored and used as the source for the backup. Ensure that all possible storage arrays are configured on the data flow if the SQL Server backup preference allows for more than one replica to become the preferred backup source.