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.
Restrictions
-
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.
Procedure
-
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.