Ok, I guess I didn't think about rolling just the logs forward, since the blocks with corruption probably have not changed an so therfore won't be in the log backups. So there should not be any corruption in the backups then, correct? Now I just need to see if I have all of my backups and T-logs on hand from Last Thursday.
Here is the full checkdb
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5500308), slot 1, text ID 982432350208 is not referenced.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:5507325) in object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). Expected value 80_PCT_FULL, actual value 95_PCT_FULL.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 3, text ID 972919734272 is referenced by page (1:6136007), slot 39, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 4, text ID 972919799808 is referenced by page (1:6136007), slot 40, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 5, text ID 982432350208 is referenced by page (1:6315359), slot 26, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 6, text ID 982432415744 is referenced by page (1:6315359), slot 27, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 7, text ID 982432481280 is referenced by page (1:6315359), slot 28, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 8, text ID 982432546816 is referenced by page (1:6315359), slot 29, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 10, text ID 982432612352 is referenced by page (1:6315359), slot 30, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 11, text ID 982432677888 is referenced by page (1:6315359), slot 31, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 12, text ID 982432743424 is referenced by page (1:6315359), slot 32, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:5507325), slot 13, text ID 982432874496 is referenced by page (1:6315359), slot 34, but was not seen in the scan.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316308), slot 0, text ID 982432415744 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316309), slot 0, text ID 982432415744 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316310), slot 0, text ID 982432481280 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316311), slot 0, text ID 982432481280 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316360), slot 0, text ID 982432546816 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316361), slot 0, text ID 982432677888 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316362), slot 0, text ID 982432677888 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316363), slot 0, text ID 982432743424 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 71777533007953920 (type LOB data). The off-row data node at page (1:6316364), slot 0, text ID 982432743424 is not referenced.
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 972919734272 owned by data record identified by RID = (1:6136007:39)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 972919799808 owned by data record identified by RID = (1:6136007:40)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432350208 owned by data record identified by RID = (1:6315359:26)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432415744 owned by data record identified by RID = (1:6315359:27)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432481280 owned by data record identified by RID = (1:6315359:28)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432546816 owned by data record identified by RID = (1:6315359:29)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432612352 owned by data record identified by RID = (1:6315359:30)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432677888 owned by data record identified by RID = (1:6315359:31)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432743424 owned by data record identified by RID = (1:6315359:32)
Msg 8929, Level 16, State 1, Line 1
Object ID 21575115, index ID 1, partition ID 72057594045136896, alloc unit ID 72057594050379776 (type In-row data): Errors found in off-row data with ID 982432874496 owned by data record identified by RID = (1:6315359:34)
CHECKDB found 0 allocation errors and 31 consistency errors in table 'tblLogging' (object ID 21575115).
Msg 8928, Level 16, State 1, Line 1
Object ID 69575286, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594043039744 (type In-row data): Page (1:5513080) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 69575286, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594043039744 (type In-row data), page (1:5513080). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 113379337 and -1.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 69575286, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594043039744 (type In-row data). Page (1:5513080) was not seen in the scan although its parent (1:5405013) and previous (1:5605197) refer to it. Check any previous errors.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 69575286, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594043039744 (type In-row data). The previous link (1:5513083) on page (1:5513081) does not match the previous page (1:5513080) that the parent (1:5405013), slot 363 expects for this page.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 69575286, index ID 1, partition ID 72057594038910976, alloc unit ID 72057594043039744 (type In-row data). Page (1:5513081) is missing a reference from previous page (1:5513083). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 5 consistency errors in table 'tblOrderApproval' (object ID 69575286).
Msg 8929, Level 16, State 1, Line 1
Object ID 373576369, index ID 1, partition ID 305957677629440, alloc unit ID 305957677629440 (type In-row data): Errors found in off-row data with ID 980962967552 owned by data record identified by RID = (1:855595:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 373576369, index ID 1, partition ID 305957677629440, alloc unit ID 305957677629440 (type In-row data): Errors found in off-row data with ID 942430158848 owned by data record identified by RID = (1:5512509:1)
Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 373576369, index ID 1, partition ID 305957677629440, alloc unit ID 71800601762136064 (type LOB data). The off-row data node at page (1:280727), slot 79, text ID 980962967552 does not match its reference from page (1:5512509), slot 1.
Msg 8974, Level 16, State 1, Line 1
Table error: Object ID 373576369, index ID 1, partition ID 305957677629440, alloc unit ID 71800601762136064 (type LOB data). The off-row data node at page (1:280727), slot 79, text ID 980962967552 is pointed to by page (1:855595), slot 0 and by page (1:5512509), slot 1.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'tblOrderLine' (ID 373576369). Data row does not have a matching index row in the index 'tblOrderLine_IDX1' (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:5512509:1) identified by (OrderLineId = 1016175) with index values 'OrderId = 116818 and OrderLineId = 1016175 and ProductNumber = 'CB6076' and SupplierCode = 'N''.
CHECKDB found 0 allocation errors and 5 consistency errors in table 'tblOrderLine' (object ID 373576369).
CHECKDB found 0 allocation errors and 41 consistency errors in database 'ind-prod7-ws'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ind-prod7-ws).
Thanks,
Tim