In which database state, the database is in single-user mode and may be repaired or restored?

Options
- OFFLINE
- SUSPECT
- EMERGENCY
- All of the above


CORRECT ANSWER : EMERGENCY

Discussion Board
EMERGENCY Database State

In EMERGENCY database state, the database is in single-user mode and may be repaired or restored. User has changed the database and set the status to EMERGENCY. The database is marked READ_ONLY, logging is disabled, and access is limited to members of the sysadmin fixed server role. EMERGENCY is primarily used for troubleshooting purposes. For example, a database marked as suspect can be set to the EMERGENCY state. This could permit the system administrator read-only access to the database. Only members of the sysadmin fixed server role can set a database to the EMERGENCY state.

Prajakta Pandit 03-10-2017 04:38 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement