Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 7901 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | DBCC2_DATABASE_IN_EMERGENCY_MODE |
| Message Text | The repair statement was not processed. This level of repair is not supported when the database is in emergency mode. |
Explanation
The database is in emergency mode and a repair level other than REPAIR_ALLOW_DATA_LOSS has been specified. Repairs cannot be made in emergency mode unless REPAIR_ALLOW_DATA_LOSS is specified.
User Action
Rerun the command and specify the REPAIR_ALLOW_DATA_LOSS option.