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.

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

  1. From the CommCell Browser, click Client Computers > client > SQL Server.

  2. Right-click the instance, point to New Subclient, and then click Database.

    The New SQL Subclient Properties dialog box is displayed.

  3. On the General tab, enter information about the subclient:

    1. In the Subclient box, type a name of the subclient.

    2. In the Subclient Type box, select a type of subclient you want to create.

  4. On the Storage Device tab, enter information about the associated storage policies:

    1. On the Data Storage Policy tab, in the Storage Policy list, select a storage policy name.

    2. On the Log Storage Policy tab, in the Storage Policy list, select a log storage policy name.

  5. On the Content tab, click Configure.

  6. In the Database Configuration dialog box, click Discover.

  7. In the Database Configuration dialog box, add the database to the specified subclient:

    1. In the Database Name column, select a database that you want to add.

    2. In the Subclient Name column, select a subclient to which you want to assign the selected database.

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

  8. To close the Database Configuration dialog box, click OK.

  9. To close the New SQL Subclient Properties dialog box, click OK.

Loading...