[EMERGENCY] DBCC DBCC_COMMAND_DETAILS executed by USER_NAME terminated abnormally due to error state ERROR_STATE. Elapsed time: HOURS hours MINUTES minutes SECONDS seconds.

Details
Product: SQL Server
Event ID: 5235
Source: MSSQLServer
Version: 9.0
Component: SQLEngine
Symbolic Name: DBCC4_ERRORLOG_SUMMARY_PREMATURE_TERMINATION
Message: [EMERGENCY] DBCC DBCC_COMMAND_DETAILS executed by USER_NAME terminated abnormally due to error state ERROR_STATE. Elapsed time: HOURS hours MINUTES minutes SECONDS seconds.
   
Explanation

This is the summary message that DBCC prints to the error log when an unexpected termination occurs while the command is running. The error state reported in the message defines the type of unexpected termination.

The following table lists and defines the error states.

Error state

Definition

State 0

The statement was terminated because of a fatal metadata corruption. This message will be accompanied by one or more instances of error 8930.

State 1

The statement was terminated because of an internal check failure. This message will be accompanied by one or more instances of error 8967.

State 2

Basic system table checks of the core storage engine system tables failed. This message will be accompanied by one or more instances of error 7984, 7985, 7986, 7987, or 7988.

State 3

DBCC emergency-mode repair failed because the database could not be started after rebuilding the transaction log. This message will be accompanied by error 7909.

State 4

A failed assertion or access violation occurred during the execution of the command.

State 5

An unknown failure occurred that unexpectedly terminated the DBCC command.

   
User Action

The following table provides the user action that is appropriate for the specified error state.

Error state

User action

State 0

Restore from backup.

State 1

Contact Microsoft Customer Service and Support (CSS).

State 2

Restore from backup.

State 3

Restore from backup.

State 4

Contact CSS.

State 5

Run the command again. If the problem persists, contact CSS.

Related:

Leave a Reply