June 8, 2010 at 12:29 pm
Hi can anybody help me to understand these DBCC errors, and suggest me possible solutions to fix them.
Thanks guys
--------------------------------------------------------------------------------------------------------------------------------------------------
SQL 2000 Enterprise SP4
--------------------------------------------------------------------------------------------------------------------------------------------------
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:8827379). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (1:8827422). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 0, index ID 0, page ID (4:5389995). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827385). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827386). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827387). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827388). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827389). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827394). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827395). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827401). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827402). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827403). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827404). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 344, index ID 3, page ID (1:8827405). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 352, index ID 3, page ID (1:8827384). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 352, index ID 3, page ID (1:8827406). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 360, index ID 3, page ID (1:8827410). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 480, index ID 3, page ID (1:8827398). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 480, index ID 3, page ID (1:8827408). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 496, index ID 3, page ID (1:8827399). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 496, index ID 3, page ID (1:8827421). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 504, index ID 3, page ID (1:8827414). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 504, index ID 3, page ID (1:8827417). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 504, index ID 3, page ID (1:8827420). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 512, index ID 3, page ID (1:8827381). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 536, index ID 3, page ID (1:8827383). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 544, index ID 3, page ID (1:8827390). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 544, index ID 3, page ID (1:8827391). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 544, index ID 3, page ID (1:8827392). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 544, index ID 3, page ID (1:8827393). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827396). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827397). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827407). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827409). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827411). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827412). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827413). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827415). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827416). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827418). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 568, index ID 3, page ID (1:8827419). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 584, index ID 3, page ID (1:8827382). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8909, Sev 16: Table error: Object ID 624, index ID 3, page ID (1:8827380). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8954, Sev 16: CHECKDB found 0 allocation errors and 3 consistency errors not associated with any single object. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 12 consistency errors in table '(Object ID 344)' (object ID 344). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 352)' (object ID 352). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 360)' (object ID 360). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 480)' (object ID 480). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID 496)' (object ID 496). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 3 consistency errors in table '(Object ID 504)' (object ID 504). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 512)' (object ID 512). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 536)' (object ID 536). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 4 consistency errors in table '(Object ID 544)' (object ID 544). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 11 consistency errors in table '(Object ID 568)' (object ID 568). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 584)' (object ID 584). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 624)' (object ID 624). [SQLSTATE 01000]
Msg 8909, Sev 16: Table error: Object ID 728, index ID 3, page ID (1:8827400). The PageId in the page header = (0:0). [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1246184481, index ID 255: Page (4:5389994) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 1246184481, index ID 255, page (4:5389994). Test (IS_ON (BUF_IOERR, bp->bstat) &&
bp->berrcode) failed. Values are 2057 and -1. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1246184481, index ID 255: Page (4:5389995) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 1246184481. The text, ntext, or image node at page (4:5389996), slot 0, text ID 2516906672128 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 1246184481. The text, ntext, or image node at page (4:5389996), slot 1, text ID 2516906934272 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 1246184481. The text, ntext, or image node at page (4:5389996), slot 2, text ID 2516906999808 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 1246184481. The text, ntext, or image node at page (4:5390004), slot 16, text ID 2516909621248 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 1246184481. The text, ntext, or image node at page (4:5390011), slot 16, text ID 2516911456256 is not referenced. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827379) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827380) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827381) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827382) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827383) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827384) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827385) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827386) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827387) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827388) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827389) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827390) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827391) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827392) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827393) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827394) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827395) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 728)' (object ID 728). [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 8 consistency errors in table 'prd.APQD' (object ID 1246184481). [SQLSTATE 01000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827396) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827397) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827398) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827399) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827400) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827401) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827402) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827403) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827404) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827405) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827406) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827407) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827408) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827409) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827410) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827411) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827412) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827413) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827414) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827415) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827416) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827417) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827418) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827419) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827420) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827421) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 1438276529, index ID 0: Page (1:8827422) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828632) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828633) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828634) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828635) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828636) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828637) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828638) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8828639) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829056) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829057) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829058) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829059) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829060) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829061) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829062) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829063) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829064) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829065) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829066) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829067) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829068) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829069) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829070) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (1:8829071) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225696) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225697) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225698) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225699) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225700) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225701) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225702) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225703) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225744) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225745) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225746) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225747) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225748) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225749) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225750) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225751) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225752) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225753) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225754) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225755) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225756) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225757) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225758) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225759) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225808) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225809) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225810) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225811) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225812) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225813) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225814) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (3:3225815) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789313) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789314) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789315) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789316) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789317) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789318) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789319) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789368) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789369) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789370) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789371) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789372) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789373) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789374) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789375) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789408) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789409) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789410) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789411) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789412) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789413) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789414) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789415) was not encountered. [SQLSTATE 42000]
Msg 8977, Sev 16: Table error: Object ID 1438276529, index ID 1. Parent node for page (4:9789448) was not encountered. [SQLSTATE 42000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 124 consistency errors in table 'prd.E071K' (object ID 1438276529). [SQLSTATE 01000]
Msg 8989, Sev 16: CHECKDB found 0 allocation errors and 177 consistency errors in database 'PRD'. [SQLSTATE 01000]
Msg 8958, Sev 16: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PRD ). [SQLSTATE 01000]
June 8, 2010 at 12:33 pm
Looks like a portion of the data file has been zeroed out, overwritten with 0s. Typically an IO subsystem problem.
Your choices are to run CheckDB with the REPAIR_ALLOW_DATA_LOSS option and accept that you will lose some data by doing so, I can't tell how much or from what table, or to restore from a clean backup.
Also make sure that you do some checks of the IO subsystem (RAID controller, SAN, ...) and see if you can find out what cause this.
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
June 8, 2010 at 3:51 pm
Thanks Gail for suggestion.
Looks like two tables got corrupted, and bad news is DBCC job is failing from last 3 weeks, i happen to look into this server and found DBCC failing. we have a backup on tape, instead of restoring whole database to 3 weeks back would you advice replacing these two tables from clean backup.
can you please detail me about the checks need to perfom in IO subsystem.
Thanks for your time.
bye
June 8, 2010 at 11:35 pm
Run CheckDB with the repair option (DB must be in single user mode). Then restore that 3 week old backup as a new DB and use something like Redgate's SQLDataCompare to sync the tables.
As for the IO subsystem, you need to check for errors, look in the RAID logs it it's a direct attached RAID array. Look in the SAN logs if it's a SAN. Use whatever diagnostics you have for it. Also check the windows event logs. Make sure that firmware and drivers are up to date.
Also, go fix up your backup and monitoring strategies. There is no excuse for a job failing for 3 weeks with no one noticing.
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
July 15, 2010 at 12:35 am
I agreed with Gail's Suggestion.
Meanwhile you can check whether dropping and recreating indexes will help....
July 15, 2010 at 1:52 am
sumit.agrawal (7/15/2010)
Meanwhile you can check whether dropping and recreating indexes will help....
It will not.
Dropping and recreating indexes only works when the corruption is in the nonclustered indexes. When that's the case, CheckDB will report a minimum repair level of repair_rebuild. That is not the case here.
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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply