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 |
|
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. |