DBCC CHECKDB and CHECKTABLE differences

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

DBCC CHECKDB and CHECKTABLE differences

Author

Topic

rebsteve
Starting Member

2 Posts

Posted - 2008-11-04 : 09:33:47

I have a database that returns a "text, ntext, or image node at page" error. I ran a DBCC CHECKDB on the database, and received, among other errors, the following:
DBCC results for 'dataPoint'.
Server: Msg 8942, Level 16, State 101, Line 1
Table error: Object ID 560721050, index ID 0, page (1:4981848). Test (sorted[i].offset >= max) failed. Slot 0, offset 0xe6 overlaps with the prior row.
There are 572115290 rows in 1960981 pages for object 'dataPoint'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'dataPoint' (object ID 560721050).

I then ran DBCC CHECKTABLE (dataPoint), and it returned the following:
DBCC results for 'dataPoint'.
There are 572381546 rows in 1961878 pages for object 'dataPoint'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

What are the differences between CHECKDB and CHECKTABLE with regards to the actual checks? How can I repair this error, we're not seeing any hardware issues?

Thanks,
STeve

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-04 : 09:37:49

moved to appropriate forum.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-11-04 : 10:22:09

CheckDB does a CheckAlloc on the database, a CheckTable on each table and view, a checkcatalog on the database (on 2005 and higher) and then validates indexed views and service broker objects.

Can you please post the entire output of DBCC CheckDB(<Database name>) WITH ALL_ErrorMsgs, No_Infomsgs

What version of SQL are you running? (output of SELECT @@version)

Do you have a clean backup, one without corruption?

How critical is the data in the 'dataPoint' table?

--
Gail Shaw
SQL Server MVP

rebsteve
Starting Member

2 Posts

Posted - 2008-11-04 : 15:56:50

Running SQL 2000 SP3. Each record by itself is not critical, but as a whole they are, so we could lose a few if necessary. We do not have a clean backup, as this problem has been going for a while, but we just became aware of it.
Results from DBCC CHECKDB (DatabaseName) WITH ALL_ErrorMsgs, No_Infomsgs:
Server: Msg 8941, Level 16, State 102, Line 1
Table error: Object ID 560721050, index ID 0, page (1:4981848). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 230, offset 0x1 is invalid.
Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 560721050, index ID 0, page (1:4981848). Test (sorted[i].offset >= max) failed. Slot 0, offset 0xe6 overlaps with the prior row.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823010615296 owned by data record identified by RID = (1:21719674:10) taskBinder_id = 259151 and idp_recordTime = 1175240301.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699535872 owned by data record identified by RID = (1:21724092:145) taskBinder_id = 259155 and idp_recordTime = 1188191688.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699470336 owned by data record identified by RID = (1:21748688:41) taskBinder_id = 259192 and idp_recordTime = 1188191688.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699732480 owned by data record identified by RID = (1:21752518:12) taskBinder_id = 259196 and idp_recordTime = 1188191689.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699601408 owned by data record identified by RID = (1:21756347:162) taskBinder_id = 259200 and idp_recordTime = 1188191688.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698421760 owned by data record identified by RID = (1:21829114:34) taskBinder_id = 266697 and idp_recordTime = 1188191807.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823010746368 owned by data record identified by RID = (1:21834004:5) taskBinder_id = 266702 and idp_recordTime = 1175240302.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582134784 owned by data record identified by RID = (1:21844095:98) taskBinder_id = 266715 and idp_recordTime = 1164784418.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'dataPoint' (object ID 560721050).
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582331392 owned by data record identified by RID = (1:21849522:64) taskBinder_id = 266721 and idp_recordTime = 1164784419.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582200320 owned by data record identified by RID = (1:21853009:64) taskBinder_id = 266725 and idp_recordTime = 1164784419.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582265856 owned by data record identified by RID = (1:21857448:141) taskBinder_id = 266730 and idp_recordTime = 1164784419.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582396928 owned by data record identified by RID = (1:21862084:15) taskBinder_id = 266735 and idp_recordTime = 1164784420.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582462464 owned by data record identified by RID = (1:21869603:51) taskBinder_id = 266743 and idp_recordTime = 1164784420.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582528000 owned by data record identified by RID = (1:21918370:174) taskBinder_id = 268288 and idp_recordTime = 1164784420.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699666944 owned by data record identified by RID = (1:21929257:169) taskBinder_id = 269746 and idp_recordTime = 1188191689.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582593536 owned by data record identified by RID = (1:21960109:149) taskBinder_id = 271195 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582659072 owned by data record identified by RID = (1:21961969:102) taskBinder_id = 271213 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582724608 owned by data record identified by RID = (1:21963829:34) taskBinder_id = 271231 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582790144 owned by data record identified by RID = (1:21965688:116) taskBinder_id = 271249 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582855680 owned by data record identified by RID = (1:21967556:66) taskBinder_id = 271267 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582921216 owned by data record identified by RID = (1:21969416:13) taskBinder_id = 271285 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290582986752 owned by data record identified by RID = (1:21971466:59) taskBinder_id = 271303 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583052288 owned by data record identified by RID = (1:21973324:33) taskBinder_id = 271321 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583117824 owned by data record identified by RID = (1:21975247:159) taskBinder_id = 271339 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583183360 owned by data record identified by RID = (1:21977106:114) taskBinder_id = 271357 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583248896 owned by data record identified by RID = (1:21978966:53) taskBinder_id = 271375 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583314432 owned by data record identified by RID = (1:21980826:7) taskBinder_id = 271393 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583379968 owned by data record identified by RID = (1:21982685:139) taskBinder_id = 271411 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583445504 owned by data record identified by RID = (1:21984561:93) taskBinder_id = 271429 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583511040 owned by data record identified by RID = (1:21986421:47) taskBinder_id = 271447 and idp_recordTime = 1164784418.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583576576 owned by data record identified by RID = (1:21989347:61) taskBinder_id = 272180 and idp_recordTime = 1164784526.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583642112 owned by data record identified by RID = (1:21991917:96) taskBinder_id = 272216 and idp_recordTime = 1164784527.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583707648 owned by data record identified by RID = (1:21992552:63) taskBinder_id = 272248 and idp_recordTime = 1164784527.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583773184 owned by data record identified by RID = (1:21993187:30) taskBinder_id = 272280 and idp_recordTime = 1164784527.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 8290583838720 owned by data record identified by RID = (1:21993812:140) taskBinder_id = 272312 and idp_recordTime = 1164784527.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698487296 owned by data record identified by RID = (1:22030536:78) taskBinder_id = 273913 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823031128064 owned by data record identified by RID = (1:22039565:118) taskBinder_id = 273928 and idp_recordTime = 1175240534.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698552832 owned by data record identified by RID = (1:22041064:35) taskBinder_id = 273931 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823017496576 owned by data record identified by RID = (1:22046170:43) taskBinder_id = 273940 and idp_recordTime = 1175240462.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698618368 owned by data record identified by RID = (1:22051479:7) taskBinder_id = 273949 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823017562112 owned by data record identified by RID = (1:22056609:15) taskBinder_id = 273958 and idp_recordTime = 1175240462.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698683904 owned by data record identified by RID = (1:22069124:170) taskBinder_id = 273967 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823017627648 owned by data record identified by RID = (1:22074238:0) taskBinder_id = 273976 and idp_recordTime = 1175240462.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698749440 owned by data record identified by RID = (1:22079517:128) taskBinder_id = 273985 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823017693184 owned by data record identified by RID = (1:22084630:138) taskBinder_id = 273994 and idp_recordTime = 1175240462.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698814976 owned by data record identified by RID = (1:22089925:91) taskBinder_id = 274003 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698880512 owned by data record identified by RID = (1:22100334:3) taskBinder_id = 274021 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698946048 owned by data record identified by RID = (1:22110741:141) taskBinder_id = 274039 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699011584 owned by data record identified by RID = (1:22121141:108) taskBinder_id = 274057 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699077120 owned by data record identified by RID = (1:22131534:73) taskBinder_id = 274075 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699142656 owned by data record identified by RID = (1:22141928:1) taskBinder_id = 274093 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699208192 owned by data record identified by RID = (1:22152319:143) taskBinder_id = 274111 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699273728 owned by data record identified by RID = (1:22162752:107) taskBinder_id = 274129 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699339264 owned by data record identified by RID = (1:22173153:72) taskBinder_id = 274147 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227699404800 owned by data record identified by RID = (1:22183538:36) taskBinder_id = 274165 and idp_recordTime = 1188191806.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823009763328 owned by data record identified by RID = (1:22333398:115) taskBinder_id = 274293 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823011008512 owned by data record identified by RID = (1:22335115:14) taskBinder_id = 274295 and idp_recordTime = 1175240538.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823009828864 owned by data record identified by RID = (1:22358319:109) taskBinder_id = 274325 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823011074048 owned by data record identified by RID = (1:22360037:8) taskBinder_id = 274327 and idp_recordTime = 1175240538.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823009894400 owned by data record identified by RID = (1:22425096:122) taskBinder_id = 274357 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823009959936 owned by data record identified by RID = (1:22450306:142) taskBinder_id = 274389 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823010025472 owned by data record identified by RID = (1:22478006:141) taskBinder_id = 274421 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823010091008 owned by data record identified by RID = (1:22515192:141) taskBinder_id = 274453 and idp_recordTime = 1175240537.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823029489664 owned by data record identified by RID = (1:22780711:92) taskBinder_id = 274886 and idp_recordTime = 1175240529.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823029555200 owned by data record identified by RID = (1:22784226:94) taskBinder_id = 274925 and idp_recordTime = 1175240529.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823031062528 owned by data record identified by RID = (1:22784360:5) taskBinder_id = 274926 and idp_recordTime = 1175240536.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 10823010680832 owned by data record identified by RID = (1:22898070:109) taskBinder_id = 275380 and idp_recordTime = 1175240301.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698290688 owned by data record identified by RID = (1:23125945:47) taskBinder_id = 277518 and idp_recordTime = 1188191857.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698225152 owned by data record identified by RID = (1:23139428:138) taskBinder_id = 277543 and idp_recordTime = 1188191926.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2134298663: Errors found in text ID 13227698356224 owned by data record identified by RID = (1:23139698:115) taskBinder_id = 277544 and idp_recordTime = 1188191857.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2134298663, index ID 255: Page (1:4981848) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 1, text ID 8290582134784 is referenced by page (1:21844095), slot 98, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 3, text ID 8290582200320 is referenced by page (1:21853009), slot 64, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 5, text ID 8290582265856 is referenced by page (1:21857448), slot 141, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 7, text ID 8290582331392 is referenced by page (1:21849522), slot 64, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 9, text ID 8290582396928 is referenced by page (1:21862084), slot 15, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 11, text ID 8290582462464 is referenced by page (1:21869603), slot 51, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 12, text ID 8290582528000 is referenced by page (1:21918370), slot 174, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 13, text ID 8290582593536 is referenced by page (1:21960109), slot 149, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 14, text ID 8290582659072 is referenced by page (1:21961969), slot 102, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 15, text ID 8290582724608 is referenced by page (1:21963829), slot 34, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 17, text ID 8290582790144 is referenced by page (1:21965688), slot 116, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 19, text ID 8290582855680 is referenced by page (1:21967556), slot 66, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 21, text ID 8290582921216 is referenced by page (1:21969416), slot 13, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 23, text ID 8290582986752 is referenced by page (1:21971466), slot 59, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 25, text ID 8290583052288 is referenced by page (1:21973324), slot 33, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 27, text ID 8290583117824 is referenced by page (1:21975247), slot 159, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 28, text ID 8290583183360 is referenced by page (1:21977106), slot 114, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 29, text ID 8290583248896 is referenced by page (1:21978966), slot 53, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 30, text ID 8290583314432 is referenced by page (1:21980826), slot 7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 31, text ID 8290583379968 is referenced by page (1:21982685), slot 139, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 32, text ID 8290583445504 is referenced by page (1:21984561), slot 93, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 33, text ID 8290583511040 is referenced by page (1:21986421), slot 47, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 34, text ID 8290583576576 is referenced by page (1:21989347), slot 61, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 35, text ID 8290583642112 is referenced by page (1:21991917), slot 96, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 36, text ID 8290583707648 is referenced by page (1:21992552), slot 63, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 37, text ID 8290583773184 is referenced by page (1:21993187), slot 30, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981848), slot 38, text ID 8290583838720 is referenced by page (1:21993812), slot 140, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981849), slot 0, text ID 8290583576576 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:4981849), slot 1, text ID 8290583838720 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2134298663, index ID 255: Page (1:5421927) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 2134298663, index ID 255, page (1:5421927). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 0, text ID 10823009763328 is referenced by page (1:5421926), slot 31, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 1, text ID 10823009828864 is referenced by page (1:5421926), slot 32, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 2, text ID 10823009894400 is referenced by page (1:5421926), slot 33, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 3, text ID 10823009959936 is referenced by page (1:5421926), slot 34, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 4, text ID 10823010025472 is referenced by page (1:5421926), slot 35, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 5, text ID 10823010091008 is referenced by page (1:5421926), slot 36, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 6, text ID 10823010615296 is referenced by page (1:5421925), slot 33, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 7, text ID 10823010680832 is referenced by page (1:5421925), slot 34, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 8, text ID 10823010746368 is referenced by page (1:5421925), slot 35, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 9, text ID 10823011008512 is referenced by page (1:5421960), slot 31, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 10, text ID 10823011074048 is referenced by page (1:5421960), slot 32, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 11, text ID 10823017496576 is referenced by page (1:22046170), slot 43, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 12, text ID 10823017562112 is referenced by page (1:22056609), slot 15, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 13, text ID 10823017627648 is referenced by page (1:22074238), slot 0, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 14, text ID 10823017693184 is referenced by page (1:22084630), slot 138, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 15, text ID 10823029489664 is referenced by page (1:22780711), slot 92, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 17, text ID 10823029555200 is referenced by page (1:22784226), slot 94, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 18, text ID 10823031062528 is referenced by page (1:22784360), slot 5, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:5421927), slot 19, text ID 10823031128064 is referenced by page (1:22039565), slot 118, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:6429060), slot 11, text ID 10823017627648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:6429060), slot 12, text ID 10823017693184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:6430211), slot 26, text ID 10823029489664 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:6436673), slot 35, text ID 10823031062528 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915972), slot 24, text ID 13227698225152 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2134298663, index ID 255: Page (1:7915973) could not be processed. See other errors for details.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 0, text ID 13227698225152 is referenced by page (1:23139428), slot 138, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 2, text ID 13227698290688 is referenced by page (1:23125945), slot 47, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 4, text ID 13227698356224 is referenced by page (1:23139698), slot 115, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 6, text ID 13227698421760 is referenced by page (1:21829114), slot 34, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 7, text ID 13227698487296 is referenced by page (1:22030536), slot 78, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 8, text ID 13227698552832 is referenced by page (1:22041064), slot 35, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 9, text ID 13227698618368 is referenced by page (1:22051479), slot 7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 11, text ID 13227698683904 is referenced by page (1:22069124), slot 170, but was not seen in the scan.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 2134298663, index ID 255, page (1:7915973), row 13. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 66 and 193.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 13, text ID 13227698749440 is referenced by page (1:22079517), slot 128, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 15, text ID 13227698814976 is referenced by page (1:22089925), slot 91, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 17, text ID 13227698880512 is referenced by page (1:22100334), slot 3, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 19, text ID 13227698946048 is referenced by page (1:22110741), slot 141, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 21, text ID 13227699011584 is referenced by page (1:22121141), slot 108, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 22, text ID 13227699077120 is referenced by page (1:22131534), slot 73, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 23, text ID 13227699142656 is referenced by page (1:22141928), slot 1, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 24, text ID 13227699208192 is referenced by page (1:22152319), slot 143, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 25, text ID 13227699273728 is referenced by page (1:22162752), slot 107, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 26, text ID 13227699339264 is referenced by page (1:22173153), slot 72, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 27, text ID 13227699404800 is referenced by page (1:22183538), slot 36, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 29, text ID 13227699470336 is referenced by page (1:21748688), slot 41, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 31, text ID 13227699535872 is referenced by page (1:21724092), slot 145, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 32, text ID 13227699601408 is referenced by page (1:21756347), slot 162, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 33, text ID 13227699666944 is referenced by page (1:21929257), slot 169, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915973), slot 34, text ID 13227699732480 is referenced by page (1:21752518), slot 12, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915974), slot 0, text ID 13227699601408 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915974), slot 1, text ID 13227699666944 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2134298663. The text, ntext, or image node at page (1:7915974), slot 2, text ID 13227699732480 is not referenced.
CHECKDB found 0 allocation errors and 155 consistency errors in table 'dataIDP' (object ID 2134298663).
CHECKDB found 0 allocation errors and 157 consistency errors in database 'EcoTOOLSDB5'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (EcoTOOLSDB5 ).

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-11-04 : 20:39:44

If you have no clean backup, your only option is to run CheckDB with the repair_allow_data_loss option. As its name implies, it will discard data. Offhand I'm not sure how much. It looks like most of the database is to the text pages, however I think that repair will discard the entire row

Paul Randal, who will probably read this fairly soon, will be able to say for sure.

If it does discard the entire row, you'll probably be loosing around 150 rows.

CheckDB with repair requires that the DB be in single user mode. Once it's complete, you may want to schedule regular integrity checks so that you can cathc this kinda thing early

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources