MSSQLSERVER_5235
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. |