Database Availability State Statuses

The possible values in the State and State_Desc columns of sys.databases are:

0 = ONLINE
1 = RESTORING
2 = RECOVERING
3 = RECOVERY_PENDING
4 = SUSPECT
5 = EMERGENCY
6 = OFFLINE
7 = COPYING (Applies to Windows Azure SQL Database)

Views – 1942

Leave a Reply