MSSQLSERVER_7901

Details

Product Name	SQL Server
Product Version	10.0
Product Build Number
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.