Excluding SQL Databases from Backups

You can exclude SQL databases from backups by defining filters based on how the databases are named. When you create a new SQL database, if the database name matches the filter, then the database is excluded from backups.

For example, you can configure a filter to exclude databases that have a name that begins with "test".

You cannot filter databases using a naming pattern for the following backup solutions:

  • Commvault Plug-in for SQL Management Studio

  • Analysis services

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Overview page appears.

  2. On the Instances tab, click the SQL instance.

    The instance page appears.

  3. On the Subclients tab, click the subclient that you want to exclude the SQL databases from the backup content.

  4. In the Content section, click View/Edit.

    The Edit content dialog box appears.

  5. On the Exclusions tab, in the Enter a database name pattern box, type the name pattern, and then click Excluding SQL Databases from Backups (1).

    For example, to exclude databases with a name that contain the string "test", type *test*. Database names with string "Test" are not excluded as the filter strings are case-sensitive.

  6. Click Save.

Loading...