Understand DBCC error messages

After the

command finishes, a message is written to the SQL Server error log.

If the DBCC command successfully executes, the message indicates a successful completion

and the amount of time that the command ran. If the DBCC command stops before completing

the check because of an error, the message indicates the command was terminated, a state

value, and the amount of time the command ran. The following table lists and describes the

state values that can be included in the message.

Description

0

Error number 8930 was raised. This indicates a metadata corruption that caused the DBCC

command to terminate.

1

Error number 8967 was raised. There was an internal DBCC error.

2

A failure occurred during emergency mode database repair.

3

This indicates a metadata corruption that caused the DBCC command to terminate.

4

An assert or access violation was detected.

5

An unknown error occurred that terminated the DBCC command.

A mini-dump file (

) is created in the SQL Server

directory whenever

detects a corruption error.

Feature Usage

Error

Reporting

features are enabled for the instance of SQL Server, the file is automatically

forwarded to Microsoft. The collected data is used to improve SQL Server functionality.

command and additional diagnostic

output. The file has restricted discretionary access-control lists (DACLs).

service account and members of the sysadmin role.

７

Note

This feature is not available in every edition of SQL Server.

section of.

DBCC CHECKTABLE

SQLDUMP<nnnn>.txt

LOG

DBCC
CHECKTABLE

DBCC CHECKTABLE