Edit

MSSQLSERVER_5235

  • Article

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 5235
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name DBCC4_ERRORLOG_SUMMARY_PREMATURE_TERMINATION
Message Text [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 SQL Server 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 1 The statement was terminated because of a fatal metadata corruption. This message is accompanied by one or more instances of error 8930.
State 2 The statement was terminated because of an internal check failure. This message is accompanied by one or more instances of error 8967.
State 3 Basic system table checks of the core storage engine system tables failed. This message is accompanied by one or more instances of error 7984, 7985, 7986, 7987, or 7988.
State 4 DBCC emergency-mode repair failed because the database could not be started after rebuilding the transaction log. This message is accompanied by error 7909.
State 5 A failed assertion or access violation occurred during the execution of the command.
State 6 An unknown failure occurred that unexpectedly terminated the DBCC command.
State 7 An abnormal termination due to error on the replica (Always On).

User Action

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

Error state User action
State 1 Restore from backup.
State 2 Contact Microsoft Customer Service and Support (CSS).
State 3 Restore from backup.
State 4 Restore from backup.
State 4 Contact CSS.
State 6 Run the command again. If the problem persists, contact CSS.

See Also

DBCC (Transact-SQL)