Automatically Discovering SQL Databases Not in Online State

By default, online SQL databases are automatically discovered. However, you can set up automatic discovery of databases that are in a state other than online.

If you are using the default settings for automatic discovery, databases in the following states are excluded:

  • Standby state

  • Restoring state

  • Suspect state (this also includes the Standby state)

  • Shutdown state (this also includes the Suspect and the Standby states)

  • Offline state

For each client, you can individually configure automatic discovery of databases in various states other than online.

Procedure

On the client computer, add the sDiscoverDatabaseStates additional setting with the database state as value.

For instructions about adding the additional setting from the CommCell Console, see Adding or Modifying an Additional Setting from the CommCell Console.

Property

Value

Name

sDiscoverDatabaseStates

Category

MSSQLAgent

Type

String

Value

Type the database state that should be discovered.

For example, to discover databases in the Suspect, Shutdown and Standby states, type:

dsuspect;shutdown;standby.

Loading...