January 7, 2010 at 2:50 pm
Hi,
We have SQL Server 2000 standard edition 32 bit with SP3. The Integrity check job failed for Mydb database and after running the command 'DBCC CHECKDB (MyDB) WITH NO_INFOMSGS, ALL_ERRORMSGS' , I got many errors as below:
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132527751168 owned by data record identified by RID = (1:61573:19)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532600832 owned by data record identified by RID = (1:61573:36)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532994048 owned by data record identified by RID = (1:61573:37)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132527620096 owned by data record identified by RID = (1:152773:54)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132527685632 owned by data record identified by RID = (1:152773:55)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532404224 owned by data record identified by RID = (1:152774:32)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532469760 owned by data record identified by RID = (1:152774:33)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532535296 owned by data record identified by RID = (1:152774:34)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532666368 owned by data record identified by RID = (1:152774:36)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532731904 owned by data record identified by RID = (1:152774:37)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532797440 owned by data record identified by RID = (1:152774:38)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532862976 owned by data record identified by RID = (1:152774:39)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132532928512 owned by data record identified by RID = (1:152774:40)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132533059584 owned by data record identified by RID = (1:152774:42)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132533125120 owned by data record identified by RID = (1:152774:43)
Msg 8929, Level 16, State 1, Line 3
Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 58858028400640 (type In-row data): Errors found in off-row data with ID 132533190656 owned by data record identified by RID = (1:152774:44)
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155517), slot 0, text ID 132527620096 is not referenced.
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155518), slot 0, text ID 132527620096 is not referenced.
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155519), slot 0, text ID 132527620096 is not referenced.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155528) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155529) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155529), slot 1, text ID 132527620096 is referenced by page (1:152773), slot 54, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155529), slot 3, text ID 132527685632 is referenced by page (1:152773), slot 55, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155530) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155531) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155532) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155533) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155534) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155534), slot 0, text ID 132527751168 is referenced by page (1:155546), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155535) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155535), slot 0, text ID 132527751168 is referenced by page (1:155546), slot 1, but was not seen in the scan.
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155863), slot 0, text ID 132532404224 is not referenced.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155872) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155873) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155874) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155875) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155875), slot 1, text ID 132532404224 is referenced by page (1:152774), slot 32, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155875), slot 3, text ID 132532469760 is referenced by page (1:152774), slot 33, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155876) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155877) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155878) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155879) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155880) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155881) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155882) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155883) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155884) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155884), slot 1, text ID 132532535296 is referenced by page (1:152774), slot 34, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155885) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155886) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155887) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155888) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155889) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155889), slot 1, text ID 132532600832 is referenced by page (1:61573), slot 36, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155889), slot 3, text ID 132532666368 is referenced by page (1:152774), slot 36, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155890) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155891) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155892) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155893) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155894) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155895) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155896) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155897) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155898) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155898), slot 1, text ID 132532731904 is referenced by page (1:152774), slot 37, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155898), slot 3, text ID 132532797440 is referenced by page (1:152774), slot 38, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155899) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155900) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155901) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155902) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155903) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155904) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155905) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155906) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155907) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155907), slot 1, text ID 132532862976 is referenced by page (1:152774), slot 39, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155907), slot 3, text ID 132532928512 is referenced by page (1:152774), slot 40, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155908) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155909) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155910) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155911) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155912) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155913) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155914) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155915) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155916) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155916), slot 1, text ID 132532994048 is referenced by page (1:61573), slot 37, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155917) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155918) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155919) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155920) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155921) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155921), slot 1, text ID 132533059584 is referenced by page (1:152774), slot 42, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155921), slot 3, text ID 132533125120 is referenced by page (1:152774), slot 43, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155922) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155923) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155924) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155925) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155926) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155926), slot 0, text ID 132533190656 is referenced by page (1:155930), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 3
Table error: page (1:155927) allocated to object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 3
Table error: Object ID 898102240, index ID 0, partition ID 58858028400640, alloc unit ID 71834977089617920 (type LOB data). The off-row data node at page (1:155927), slot 0, text ID 132533190656 is referenced by page (1:155930), slot 1, but was not seen in the scan.
CHECKDB found 0 allocation errors and 102 consistency errors in table 'tblStmtValidations' (object ID 898102240).
CHECKDB found 0 allocation errors and 102 consistency errors in database 'Mydb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Mydb).
Can you please me what will be the correct steps I need to take now..
Thanks
January 7, 2010 at 4:13 pm
Restore from the latest good backup and apply transaction log backups up to current point in time.
Other than that - I think you are going to lose data.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 8, 2010 at 1:12 am
Restore your last good backup and any transaction log backups you have. Once you've done that, do some root-cause analysis. Look in the event logs for hardware (specifically IO) related error messages. From a cursory glance, it looks like a sizeable portion of the data file has been garbled.
Oh, and this is not the checkDB output from a SQL 2000 database. It's from 2005 or 2008. SQL 2000 would not mention partition ID or allocation units, because it did not have them.
Please run this to confirm what version you're dealing with.
SELECT @@version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply