Subclient Properties (General) - SQL Server Agent

Use this dialog box to manage the SQL Server database properties.

Client Name

Displays the name of the client computer to which this subclient belongs.

Agent

Displays the name of the agent to which this subclient belongs.

Instance

Displays the name of the instance to which this subclient belongs.

Subclient

Displays the name of this subclient.

You can use this space to type or modify the name of the subclient.

Backup Staging Directory

Click Browse to change the staging location for backup operation of Analysis Services databases.

This option is visible only if the subclient is created from an Analysis Services instance.

Allow multiple data readers for Backup Copy

Specifies whether multiple data reads are allowed for a single Windows physical drive during backups on this subclient. This should be selected only for specialized hardware such as RAID, or possibly in the case of spanned volumes.

Subclient Type

You can create four types of subclients. Use these subclients for backing up different types of databases based on their recovery models.

  • Full Recovery Model - Use this subclient type to back up the databases where recovery model is set to full.

  • Simple Recovery Model - Use this subclient type to back up the databases where recovery model is set to simple.

  • System Databases - Use this subclient type to back up the SQL Server system databases like master, msdb, and model.

  • None - Use this subclient type to back up any database type.

Disable Auto-Discovery

Select to disable the auto-discovery and pre-assignment of SQL databases to the default subclient or the Full Recovery Model, Simple Recovery Model, or System Databases user-defined subclient types. By default, SQL databases are automatically discovered and assigned for these subclients.

Description

Use this field to enter a description about the entity. This description can include information about the entity's content, cautionary notes, etc.

Loading...