DBBC CheckDB Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

DBBC CheckDB Error

Author

Topic

itadmins590
Starting Member

4 Posts

Posted - 2008-06-26 : 13:53:05

Our DBA left and are in the middle of getting a replacement. But we are having issues when we do a backup of the this database I know some SQL but not as much as a DBA

when I run dbcc checkdb ('mydb')WITH ALL_ERRORMSGS, NO_INFOMSGS

I get the following errors. Can anyone help decipher this.

Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC which prevented further processing. Please contact Product Support.

Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

Msg 8928, Level 16, State 1, Line 1
Object ID 293576084, index ID 1, partition ID 72057594233749504, alloc unit ID 72057594245218304 (type In-row data): Page (1:149976) could not be processed. See other errors for details.

Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 293576084, index ID 1, partition ID 72057594233749504, alloc unit ID 72057594245218304 (type In-row data), page (1:149976). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 293576084, index ID 1, partition ID 72057594233749504, alloc unit ID 72057594245218304 (type In-row data). Page (1:149976) was not seen in the scan although its parent (1:132180) and previous (1:149975) refer to it. Check any previous errors.

Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 293576084, index ID 1, partition ID 72057594233749504, alloc unit ID 72057594245218304 (type In-row data). Page (1:149977) is missing a reference from previous page (1:149976). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'tbl_LabelEntry' (object ID 293576084).

Any help would be greatly appreciated.

Regards,

Adrian

maninder
Posting Yak Master

100 Posts

Posted - 2008-06-26 : 22:03:53

This counds like a CLUSTER INDEX PAGE is CORRUPT as per PAge(1: 149976 to 77)
Try to post the RESULTS of
DBCC TRACEON (3604)
DBCC PAGE ('dbname', 1, 149975, 3); Post the REsults then
DBCC PAGE ('dbname', 1, 149978, 3) and post the results

Maninder

itadmins590
Starting Member

4 Posts

Posted - 2008-07-08 : 09:46:10

DBCC PAGE('mydb'), 1, 149975, 3);
PAGE: (1:149975)

BUFFER:

BUF @0x037BEA88

bpage = 0x5CA0C000 bhash = 0x00000000 bpageno = (1:149975)
bdbid = 11 breferences = 0 bUse1 = 5742
bstat = 0xc00009 blog = 0x159a2159 bnext = 0x00000000

PAGE HEADER:

Page @0x5CA0C000

m_pageId = (1:149975) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200
m_objId (AllocUnitId.idObj) = 3163 m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594245218304
Metadata: PartitionId = 72057594233749504 Metadata: IndexId = 1
Metadata: ObjectId = 293576084 m_prevPage = (1:149974) m_nextPage = (1:149976)
pminlen = 17 m_slotCnt = 368 m_freeCnt = 0
m_freeData = 7456 m_reservedCnt = 0 m_lsn = (35568:2197:38)
m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
m_tornBits = -1753150020

Allocation Status

GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:145584) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED

Slot 0 Offset 0x60 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C060

00000000: 10001100 89020000 e3670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 0 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 0 Column 1 Offset 0x8 Length 4

ItemId = 157667

Slot 0 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 0 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 1 Offset 0x74 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C074

00000000: 10001100 89020000 e4670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 1 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 1 Column 1 Offset 0x8 Length 4

ItemId = 157668

Slot 1 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 1 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 2 Offset 0x88 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C088

00000000: 10001100 89020000 e5670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 2 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 2 Column 1 Offset 0x8 Length 4

ItemId = 157669

Slot 2 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 2 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 3 Offset 0x9c Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C09C

00000000: 10001100 89020000 e6670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 3 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 3 Column 1 Offset 0x8 Length 4

ItemId = 157670

Slot 3 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 3 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 4 Offset 0xb0 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C0B0

00000000: 10001100 89020000 e7670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 4 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 4 Column 1 Offset 0x8 Length 4

ItemId = 157671

Slot 4 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 4 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 5 Offset 0xc4 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C0C4

00000000: 10001100 89020000 e8670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 5 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 5 Column 1 Offset 0x8 Length 4

ItemId = 157672

Slot 5 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 5 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 6 Offset 0xd8 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C0D8

00000000: 10001100 89020000 e9670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 6 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 6 Column 1 Offset 0x8 Length 4

ItemId = 157673

Slot 6 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 6 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 7 Offset 0xec Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C0EC

00000000: 10001100 89020000 ea670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 7 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 7 Column 1 Offset 0x8 Length 4

ItemId = 157674

Slot 7 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 7 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 8 Offset 0x100 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C100

00000000: 10001100 89020000 eb670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 8 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 8 Column 1 Offset 0x8 Length 4

next post is continuation of output since it was a lot of data

itadmins590
Starting Member

4 Posts

Posted - 2008-07-08 : 09:49:14

cont'd

Slot 8 Column 1 Offset 0x8 Length 4

ItemId = 157675

Slot 8 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 8 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 9 Offset 0x114 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C114

00000000: 10001100 89020000 ec670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 9 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 9 Column 1 Offset 0x8 Length 4

ItemId = 157676

Slot 9 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 9 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 10 Offset 0x128 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C128

00000000: 10001100 89020000 ed670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 10 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 10 Column 1 Offset 0x8 Length 4

ItemId = 157677

Slot 10 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 10 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 11 Offset 0x13c Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C13C

00000000: 10001100 89020000 ee670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 11 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 11 Column 1 Offset 0x8 Length 4

ItemId = 157678

Slot 11 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 11 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 12 Offset 0x150 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C150

00000000: 10001100 89020000 ef670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 12 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 12 Column 1 Offset 0x8 Length 4

ItemId = 157679

Slot 12 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 12 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 13 Offset 0x164 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C164

00000000: 10001100 89020000 f0670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 13 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 13 Column 1 Offset 0x8 Length 4

ItemId = 157680

Slot 13 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 13 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 14 Offset 0x178 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C178

00000000: 10001100 89020000 f1670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 14 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 14 Column 1 Offset 0x8 Length 4

ItemId = 157681

Slot 14 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 14 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 15 Offset 0x18c Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C18C

00000000: 10001100 89020000 f2670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 15 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 15 Column 1 Offset 0x8 Length 4

ItemId = 157682

Slot 15 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 15 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 16 Offset 0x1a0 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C1A0

00000000: 10001100 89020000 f3670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 16 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 16 Column 1 Offset 0x8 Length 4

ItemId = 157683

Slot 16 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 16 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 17 Offset 0x1b4 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C1B4

00000000: 10001100 89020000 f4670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 17 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 17 Column 1 Offset 0x8 Length 4

ItemId = 157684

Slot 17 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 17 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 18 Offset 0x1c8 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C1C8

00000000: 10001100 89020000 f5670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 18 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 18 Column 1 Offset 0x8 Length 4

ItemId = 157685

Slot 18 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 18 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 19 Offset 0x1dc Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C1DC

00000000: 10001100 89020000 f6670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 19 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 19 Column 1 Offset 0x8 Length 4

ItemId = 157686

Slot 19 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 19 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 20 Offset 0x1f0 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C1F0

00000000: 10001100 89020000 f7670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 20 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 20 Column 1 Offset 0x8 Length 4

ItemId = 157687

Slot 20 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 20 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 21 Offset 0x204 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C204

00000000: 10001100 89020000 f8670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 21 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 21 Column 1 Offset 0x8 Length 4

ItemId = 157688

Slot 21 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 21 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 22 Offset 0x218 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C218

00000000: 10001100 89020000 f9670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 22 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 22 Column 1 Offset 0x8 Length 4

ItemId = 157689

Slot 22 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 22 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 23 Offset 0x22c Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C22C

00000000: 10001100 89020000 fa670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 23 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 23 Column 1 Offset 0x8 Length 4

ItemId = 157690

Slot 23 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 23 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 24 Offset 0x240 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C240

00000000: 10001100 89020000 fb670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 24 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 24 Column 1 Offset 0x8 Length 4

ItemId = 157691

Slot 24 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 24 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 25 Offset 0x254 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C254

00000000: 10001100 89020000 fc670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 25 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 25 Column 1 Offset 0x8 Length 4

ItemId = 157692

Slot 25 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 25 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 26 Offset 0x268 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C268

00000000: 10001100 89020000 fd670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 26 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 26 Column 1 Offset 0x8 Length 4

ItemId = 157693

Slot 26 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 26 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 27 Offset 0x27c Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C27C

00000000: 10001100 89020000 fe670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 27 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 27 Column 1 Offset 0x8 Length 4

ItemId = 157694

Slot 27 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 27 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 28 Offset 0x290 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C290

00000000: 10001100 89020000 ff670200 000a0900 †.........g......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 28 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 28 Column 1 Offset 0x8 Length 4

ItemId = 157695

Slot 28 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 28 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 29 Offset 0x2a4 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C2A4

00000000: 10001100 89020000 00680200 000a0900 †.........h......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 29 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 29 Column 1 Offset 0x8 Length 4

ItemId = 157696

Slot 29 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 29 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 30 Offset 0x2b8 Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C2B8

00000000: 10001100 89020000 01680200 000a0900 †.........h......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 30 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 30 Column 1 Offset 0x8 Length 4

ItemId = 157697

Slot 30 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 30 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 31 Offset 0x2cc Length 20

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x65F6C2CC

00000000: 10001100 89020000 02680200 000a0900 †.........h......
00000010: 000400f0 ††††††††††††††††††††††††††††....

Slot 31 Column 0 Offset 0x4 Length 4

LabelId = 649

Slot 31 Column 1 Offset 0x8 Length 4

ItemId = 157698

Slot 31 Column 2 Offset 0xc Length 1 (Bit position 0)

Recursive = 0

Slot 31 Column 3 Offset 0xd Length 4

VersionFrom = 2314

Slot 32 Offset 0x2e0 Length 20

itadmins590
Starting Member

4 Posts

Posted - 2008-07-08 : 09:51:56

is there specific data that you are looking for? there is just too much data that that returns

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-07-08 : 13:46:10

You've hit a bug in CHECKDB. See [url]http://www.sqlskills.com/blogs/paul/2008/05/22/CHECKDBBugThatPeopleAreHittingMsg8967Level16State216.aspx[/url].

You need to run CHECKDB on your own database snapshot or using WITH TABLOCK (see the blog article above) to see the whole list of errors.

Thanks

Paul Randal
SQL Server MVP, Managing Director, SQLskills.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources