InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:40:13 GMT20http://www.sqlservercentral.com/Forums/Topic802342-1390-1.aspxhere is the results of the DBCC CHECKTABLE on the 2 tables I have issues with:dbcc checktable('Web_claim') Server: Msg 8928, Level 16, State 1, Line 1 Object ID 294292108, index ID 0: Page (1:1834754) could not be processed. See other errors for details. Server: Msg 8944, Level 16, State 1, Line 1 Table error: Object ID 294292108, index ID 0, page (1:1834754), row 62. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 154 and 53. DBCC results for 'Web_Claim'. There are 918513 rows in 6767 pages for object 'Web_Claim'. CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Web_Claim' (object ID 294292108). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (Prod.dbo.Web_Claim ). dbcc checktable('Claim_item') Server: Msg 8928, Level 16, State 1, Line 1 Object ID 1618820829, index ID 0: Page (1:1835914) could not be processed. See other errors for details. Server: Msg 8944, Level 16, State 1, Line 1 Table error: Object ID 1618820829, index ID 0, page (1:1835914), row 8. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1263 and 398. DBCC results for 'Claim_Item'. There are 5402810 rows in 314154 pages for object 'Claim_Item'. CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Claim_Item' (object ID 1618820829). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (Prod.dbo.Claim_Item ). And also one more thing SELECT COUNT(*) FROM Web_CLAIM --918,646 (DBCC 918513 , so i guess a loss of 133 rows)SELECT COUNT(*) FROM Claim_item --5,402,828 (DBCC 5402810, so i guess a loss of 8 rows)Now I know the count of rows I might lose, but can I avoid losing it or could i in anyway identify the rows which I am gonna lose. And we cant restore from the recent backups because this corruption happened 2 months back.Tue, 13 Oct 2009 13:09:59 GMTbaposts