Loading...

Configuring Subclients to Back Up SQL Files and Filegroups

You can back up specific files in a large database that require frequent backups by adding these files to a user-defined subclient.

For example, tables consisting of records entered on a daily basis may require nightly backups, whereas tables consisting of records entered on a quarterly basis may require only monthly backups. You can create a user-defined subclient and add all the files and filegroups that require nightly backups.

We recommend that you configure filegroups instead of individual files because filegroups require less overall maintenance. They reduce the need to manually add or remove individual files from the subclient.

Before You Begin

Verify that a full backup was run on the database containing the user-defined files and filegroups from the SnapProtect software.

Procedure

  1. In the CommCell Browser, click Client Computers > client > SQL Server.
  2. Right-click the instance, point to New Subclient, and then click Files/File Group.

    The New SQL Subclient Properties dialog box is displayed.

  3. On the General tab, in the Subclient box, type a name of the subclient to which you want to add a file or filegroup.
  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 storage policy name.
  5. Click the Content tab, and then click Configure.

    The File/File Group Configuration dialog box is displayed.

  6. From the Database list, select the database containing the files and the filegroups that you want to back up, and click Discover.
  7. In the File/File Group Configuration dialog box, add the files and filegroups to the specified subclient:
    1. In the Name column, expand and select the file or filegroup node that you want to add.
    2. In the Subclient column, select a subclient to which you want to assign the selected file or filegroup.
    3. Verify that you have assigned at least one file or filegroup to the subclient.

    Repeat this step for all the file or filegroup that you want to assign to the subclient.

  8. To close the File/File Group Configuration dialog box, click OK.
  9. To close the New SQL Subclient Properties dialog box, click OK.

Related Topic

Configuring Subclients for Backing Up a Group of Databases