dbcc_faults

The dbcc_faults table provides a description of each fault detected by dbcc checkstorage.

The primary key is the combination of dbid, id, indid, partitionid, devid, opid, faultid, and type_code

Columns

The columns for dbcc_faults are:

Column name

Datatype

Description

dbid

smallint

Identifies the target database.

id

smallint

Identifies the table. The value is derived from sysindexes and sysobjects.

indid

smallint

Identifies the index. The value is derived from sysindexes.

partitionid

int

Identifies the partition. The value is derived from sysindexes and syspartitions. Counters are maintained for page ranges, so “partition” refers to the defined object-page affinity, rather than the actual object page chain.

devid

int

Identifies the disk device. The value is derived from sysdevices.

opid

smallint

Identifies the dbcc operation that was performed.

faultid

int

Provides a unique sequence number assigned to each fault recorded for the operation.

type_code

int

Identifies the type of fault. Valid values are 100000 – 100032. They are described in dbcc_types.

status

int
Classifies the fault. Valid values are:

  • 0 – soft fault, possibly transient.

  • 1– hard fault.

  • 2 – soft fault that proved to be transient.

  • 3 – soft fault upgraded to a hard fault.

  • 5 – repaired hard fault.

  • 7 – repaired upgraded hard fault.

  • 9 – hard fault not rapirable.

  • 11 – soft fault upgraded to a hard fault and not repairable.

  • 16 – soft fault, object dropped (inaccessible).

  • 17 – hard fault, object dropped (inaccessible).

  • 18 – transient soft fault, object dropped (inaccessible).

  • 19 – soft fault upgraded to a hard fault and object dropped (inaccessible).

For more information, see the System Administration Guide.
Parent topic: dbccdb Tables
Related reference
dbcc_types