dbcc_faults

Description

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


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 Table 2-1.

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.


Primary key

Combination of dbid, id, indid, partitionid, devid, opid, faultid, and type_code