SQL DATABASE MODES OF OPERATION

SQL Server database following states but I will only write little about the first 4 as these are most occur scenario's

1)ONLINE (Available – online for data)

2)OFFLINE

3)RESTORING

4)RECOVERING

5)RECOVERY PENDING

6)SUSPECT

7)EMERGENCY (Limited Availability)

1)ONLINE (Available – online for data): Database is operational and live.

2)OFFLINE: Database is not available

3)RESTORING: Database is alive but not available for any outside operation. This states normally shows up when we leave the DB in norecovery mode.

4)RECOVERING:Database is alive but in a process of getting recovered.