Online Documentation for SQL Administrator for SQL Server

Database states


db_online - online;

offline_db16 - offline;

standby_db16 - standby (read-only for restore log);

restoring_db16 - restoring;

db_error16 - emergency;

db_readonly_emergency16 - emergency and read-only;

db_single_user16 - single-user;

db_readonly_single_user16 - emergency and single-user;

db_standby_single_user16 - standby and single-user;

db_readonly_standby_single_user16 - standby, single-user and read-only;

db_readonly_standby16 - standby and read-only;

db_readonly16_2 - read-only;

recovering_db3_16 - recovering, recovery pending, suspect.