Configuring a Subclient to Not Remove Deleted Databases

You can configure a subclient to not remove deleted databases. By default, when databases are deleted from the SQL Server they are also removed from the subclient during the next backup operation.

You can keep deleted databases from being removed from a subclient's content by using one of the following methods:

• On the SQL Agent Configuration dialog box, select the Do not remove database from subclient if database is non-existent check box. This sets the property for the entire CommCell environment, and impacts all SQL clients.

• Create the additional setting nIgnoreNonExistentDB. This sets a SQL client-level property.

  Note

  This additional setting is not supported for SQL Availability Group subclients.

Procedure

Change the Setting from the Control Panel for the Entire CommCell Environment

This procedure sets the necessary property for the whole CommCell environment. Consequently, when the setting is changed in this procedure, each SQL agent is configured to keep deleted databases from being removed from a subclient's content.

1. On the CommCell Console ribbon, click the Home tab, and then click Control Panel.

2. In the User pane, click SQL iDataAgent.

   The SQL Agent Configuration (SQL Configuration) dialog box appears.

3. On the SQL Configuration tab, select the Do not remove database from subclient if database is non-existent check box.

4. Click OK.

Create the Additional Setting nIgnoreNonExistentDB for the Individual Client Level

This procedure sets the necessary property at the SQL client computer level.

1. From the CommCell Browser, expand Client Computers.

2. Right-click the desired client, and then click Properties.

3. In the Client Computer Properties dialog box, click Advanced.

4. In the Advanced Client Properties dialog box, click the Additional Settings tab, then click Add.

5. In the Add Additional Settings dialog box, set up the additional setting:

   1. In the Name box, type nIgnoreNonExistentDB.

   2. In the Category list, select MSSQLAgent.

   3. In the Type list, select INTEGER.

   4. In the Value box, type 0.

   5. Click OK.

6. Click OK to close the Advanced Client Properties dialog box.

7. Click OK to close the Client Computer Properties dialog box.