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.
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:
|
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. |