Creating User-Defined Subclients to Back Up a Group of SQL Databases
You can back up specific databases at a particular time or frequency by adding the databases to a user-defined subclient. There are three types of subclients that you can create. 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 the recovery model is set to Full.
- Simple Recovery Model
Use this subclient type to back up the databases where the recovery model is set to Simple.
- System Databases
Use this subclient type to back up the SQL Server system databases, such as master, msdb, and model.
- Databases present in the user-defined subclients will be excluded from the default subclient.
- Auto-discovery of a new database is disabled during a backup operation if it is neither a system database nor its recovery model is set to Full or Simple.
- Auto Discovery is not available for user-defined subclients that are part of a SQL Availability group client.
- From the CommCell Browser, click Client Computers > client > SQL Server.
- Right-click the instance, point to New Subclient, and then click Database.
The New SQL Subclient Properties dialog box is displayed.
- On the General tab, enter information about the subclient:
- In the Subclient box, type a name of the subclient.
- In the Subclient Type box, select a type of subclient you want to create.
- On the Storage Device tab, enter information about the associated storage policies:
- On the Data Storage Policy tab, in the Storage Policy list, select a storage policy name.
- On the Log Storage Policy tab, in the Storage Policy list, select a log storage policy name.
- On the Content tab, click Configure.
- In the Database Configuration dialog box, click Discover.
- In the Database Configuration dialog box, add the database to the specified subclient:
- In the Database Name column, select a database that you want to add.
- In the Subclient Name column, select a subclient to which you want to assign the selected database.
- Verify that you have assigned at least one database to the subclient.
Repeat this step for all the databases that you want to assign to the subclient.
- To close the Database Configuration dialog box, click OK.
- To close the New SQL Subclient Properties dialog box, click OK.
Last modified: 7/26/2018 8:03:56 PM