October 6, 2015 at 7:57 am
I am upgrading the database from SQL 2008 R2 to SQL 2012 enterprise. I took a backup of the database and restored in 2012. The restoration went well. My DATA PURITY check failed with the following message. How can I fix this error on table? Thanks
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). Page (1:49947) is missing a reference from previous page (1:203350). Possible chain linkage problem.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). Page (1:49949) is missing a reference from previous page (1:203359). Possible chain linkage problem.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). Page (1:49955) is missing a reference from previous page (1:203378). Possible chain linkage problem.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). Page (1:49959) is missing a reference from previous page (1:203426). Possible chain linkage problem.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). Page (1:50785) is missing a reference from previous page (1:44457). Possible chain linkage problem.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:203350)->next = (1:203140), but (1:203140)->Prev = (1:49947).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:209719) on page (1:203351) does not match the previous page (1:49948) that the parent (1:203619), slot 25 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49948)->next = (1:203351), but (1:203351)->Prev = (1:209719).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:209728) on page (1:203362) does not match the previous page (1:49950) that the parent (1:203619), slot 58 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49950)->next = (1:203362), but (1:203362)->Prev = (1:209728).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:209729) on page (1:203363) does not match the previous page (1:49951) that the parent (1:203619), slot 61 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49951)->next = (1:203363), but (1:203363)->Prev = (1:209729).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:209732) on page (1:203369) does not match the previous page (1:49953) that the parent (1:203619), slot 74 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49953)->next = (1:203369), but (1:203369)->Prev = (1:209732).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:17464) on page (1:203370) does not match the previous page (1:49954) that the parent (1:203619), slot 79 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49954)->next = (1:203370), but (1:203370)->Prev = (1:17464).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). The previous link (1:209734) on page (1:203381) does not match the previous page (1:49956) that the parent (1:203619), slot 99 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:49956)->next = (1:203381), but (1:203381)->Prev = (1:209734).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:203426)->next = (1:203421), but (1:203421)->Prev = (1:49959).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:203359)->next = (1:209727), but (1:209727)->Prev = (1:49949).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:203378)->next = (1:209734), but (1:209734)->Prev = (1:49955).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 263671987, index ID 1, partition ID 72057594052083712, alloc unit ID 72057594062635008 (type In-row data). B-tree chain linkage mismatch. (1:44457)->next = (1:232663), but (1:232663)->Prev = (1:50785).
DBCC results for 'TABLE1.
There are 148647 rows in 85289 pages for object "'TABLE1".
CHECKDB found 0 allocation errors and 22 consistency errors in table 'TABLE1' (object ID 263671987).
October 6, 2015 at 8:50 am
Does the 2008 db pass the integrity check?
😎
October 6, 2015 at 9:07 am
I fixed it by dropping the indexes on the table and recreating it.
While recreating unique index I got error and found out that here were 28 rows that had duplicate value on Identity key. I was not sure how that happened. I deleted the duplicate keeping the unique ones, recreated the indexes and ran the data purity check again and it passed.
So, the bottom line is recreating the indexes on the table pointed me to the right direction.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply