Different States of Database

What are the states of the database?

There are seven states, they are as follows

• Online
• Offline
• Standby
• Suspect
• Restoring
• Single user
• Restricted user

Online: When the database is in online mode, it is available to access the data.

Offline: Here the database is unavailable and it is used when to move the database files from one disk to other.

Standby: When the database is in standby mode it has only read access. This mode is used to restore the secondary server in the log shipping configuration.

Suspect: The database is unavailable because of there is corrupted/deleted the database files ie., data file and log file. 

Restoring: There may be restoring of one or more files, it is seen in the mirror server in mirroring configuration.

Single user: Only one connection is allowed for database, it is used in  restarting the server and rebuilding master database.

Restricted user: Only sysadmins can access the database.