Disabling Automatic Discovery of SQL Databases

By default, automatic discovery of new SQL databases is enabled and assigned to the default subclient, ensuring that the newly added SQL databases are regularly accounted for during backups.

Automatic discovery is also enabled by default for the user-defined subclients that are used to back up the following databases:

  • System databases

  • Databases where the recovery model is set to Full

  • Databases where the recovery model is set to Simple

Note

Auto Discovery is not available for user-defined subclients that are part of a SQL Availability group client.

Databases that are already associated to a default subclient or a user-defined subclient are excluded from automatic discovery.

If you created two databases with the same name, and the SQL Server collation option is set to case-sensitive, only one database is discovered.

Procedure

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

  2. Right-click a subclient for which you want to disable the automatic discovery of databases, and then click Properties.

    The Subclient Properties dialog box is displayed.

  3. On the General tab, select the Disable Auto-Discovery check box, and then click OK.

Manually Discovering SQL Databases

Automatically Discovering Databases Not in Online State

Loading...