Consistency Issues - 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

Consistency Issues

Author

Topic

PCpsyco
Starting Member

11 Posts

Posted - 2008-04-15 : 17:58:26

I ran DBCC CHECKDB ('DBNAME', repair_rebuild)and I got a whole bunch of errors and would like to know how to fix.
Any help would be appreciated.

here is part of the error message

Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-15 : 18:04:52

I am moving this to the proper forum where Paul Randall frequents.

I believe Paul will need the entire output in order to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

PCpsyco
Starting Member

11 Posts

Posted - 2008-04-15 : 18:24:32

thanks I can post everything but it is large

DBCC results for 'eetdb'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45520). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 24, offset 0x50 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45520). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x18 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45521). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x26 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45521). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45522). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 114, offset 0x12 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45522). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x72 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45523), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45523), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
Repairing this error requires other errors to be corrected first.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45540). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x3e is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45540). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45541). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x2e is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45541). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45542). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 24, offset 0x10 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45542). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x18 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45543). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 52, offset 0x4c is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45543). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x34 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45544). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 50, offset 0xa is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45544). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x32 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45545). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 106, offset 0x2 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45545). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x6a overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45546). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x3e is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45546). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45547), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45547), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
Repairing this error requires other errors to be corrected first.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45564). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x36 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45564). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45565), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 8.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45565), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 8.
Repairing this error requires other errors to be corrected first.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45566). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 24, offset 0x58 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45566). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x18 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45568). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 107, offset 0x3 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45568). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x6b overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45569). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x3e is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45569). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45570). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 24, offset 0x10 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45570). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x18 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45571), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45571), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
Repairing this error requires other errors to be corrected first.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45588). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x26 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45588). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45589). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 54, offset 0x36 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45589). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x36 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45590). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 109, offset 0x2d is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45590). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x6d overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45591). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 113, offset 0x9 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45591). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x71 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45592), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 16.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45592), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 16.
Repairing this error requires other errors to be corrected first.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45593). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 112, offset 0x10 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45593). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x70 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45594), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 7.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45594), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 7.
Repairing this error requires other errors to be corrected first.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45595), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8944, Level 16, State 12, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613244301312 (type Unknown), page (3:45595), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 25 and 17.
Repairing this error requires other errors to be corrected first.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47364). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7649 and 7376.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47365). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7623 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47366). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7647 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47367). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 405, offset 0x2 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47367). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x195 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47368). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7639 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47369). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7599 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47370). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7647 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613293649920 (type Unknown), page (4:47371). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7603 and 7366.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47316). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7443 and 7370.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47317). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7451 and 7374.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47318). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7451 and 7378.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47319). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7439 and 7376.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47320). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7439 and 7376.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47321). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7451 and 7370.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47322). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7451 and 7382.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47323). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7439 and 7372.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47340). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47341). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7455 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47342). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47343). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7455 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47344). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47345). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7455 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47346). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7527 and 7368.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47347). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7535 and 7412.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47436). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47437). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7451 and 7382.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47438). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47439). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7455 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47440). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7447 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47441). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7455 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47442). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7663 and 7384.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613323141120 (type Unknown), page (4:47443). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7603 and 7382.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47244). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 379, offset 0x1 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47244). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x17b overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47245). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7580 and 7402.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47246). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47247). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47248). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7580 and 7422.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47249). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47250). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7612 and 7326.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47251). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 321, offset 0x1 is invalid.
Repairing this error requires other errors to be corrected first.
Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47251). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x141 overlaps with the prior row.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47268). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7380 and 7302.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47269). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47270). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7604 and 7326.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47271). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47292). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7428 and 7390.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47293). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47294). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47295). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47296). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47297). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47298). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47299). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7360 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47388). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7352 and 7344.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47389). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7352 and 7344.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47390). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7628 and 7354.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47391). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7352 and 7344.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47392). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7372 and 7318.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47393). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7596 and 7322.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47394). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47395). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47412). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7604 and 7326.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47413). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47414). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7592 and 7328.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47415). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7364 and 7306.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47416). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7604 and 7326.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47417). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7376 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47418). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7368 and 7308.
The repair level on the DBCC statement caused this repair to be bypassed.
Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057613362397184 (type Unknown), page (4:47419). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 7604 and 7326.
The repair level on the DBCC statement caused this repair to be bypassed.

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-04-15 : 21:02:51

Why did you run repair straight away? Do you usually run CHECKDB like that or were you attempting to repair known corruption?

You have a huge amount of corruption. If you run repair (and you'll need to use REPAIR_ALLOW_DATA_LOSS as CHECKDB will have said) you will lose data. Do you have any backups at all?

Do you know what happened to cause the corruption in the first place?

Thanks

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

PCpsyco
Starting Member

11 Posts

Posted - 2008-04-15 : 22:41:52

I'm new at all this. what I think happend by looking at the logs is that the server rebooted during normal hours of operations. can this have caused the damage? It is a small time company and they dont have any backups in place, so they said anything that I could do would help, and since I'm new at this myself I thought I would come to the experts.

is there something else I can do?

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2008-04-16 : 02:01:45

Nope - with no backups you have no choice. Make sure they know they will lose data and need to start taking backups.

My guess would be a power outage caused the server to reboot and they had some torn-pages as their hard-drives do not have battery back-up.

Thanks

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

PCpsyco
Starting Member

11 Posts

Posted - 2008-04-16 : 14:16:14

Hey thanks a lot. I went ahead and proceeded with the allowing of data lost and it seems to have fixed the problem with minimal data lost. I explained that the doged a bullet and automated their backups for them.

thanks
Andy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources