1. Home
  2. Service Check Reference
  3. MSSQL Database States Check

MSSQL Database States Check

Object Type: Service Check

Service Check Category: System Checks

Passive: No

Description: This service check can be used to create alarms for database states. The alarm parameters are configurable so that you can choose which states to alarm on.

The possible states available to monitor on are:

Code State Application Restrictions
0 ONLINE
1 RESTORING
2 RECOVERING SQL Server 2008 through SQL Server 2017
3 RECOVERY_PENDING SQL Server 2008 through SQL Server 2017
4 SUSPECT
5 EMERGENCY SQL Server 2008 through SQL Server 2017
6 OFFLINE SQL Server 2008 through SQL Server 2017
7 COPYING Azure SQL Database active geo-replication
10 OFFLINE_SECONDARY Azure SQL Database active geo-replication
Updated on November 22, 2019

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Reply