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.