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
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances tab, click the SQL instance.
The instance page appears.
-
On the Subclients tab, click the subclient that you want to exclude the SQL databases from the backup content.
-
In the Content section, click View/Edit.
The Edit content dialog box appears.
-
On the Exclusions tab, in the Enter a database name pattern box, type the name pattern, and then click
.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.
-
Click Save.