question

routsql avatar image
routsql asked

DBCC Checkdb repair cmd not fixing errors

Hi

I have use REPAIR_ALLOW_DATA_LOSS cmd still error is there

Note: This above table clustered index having 560 GB of size

DBCC results for 'tbl_user_location_history'.
Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1 will be rebuilt.
Could not repair this error.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Index node page (1:606814), slot 55 refers to child page (1:13987932) and previous child (1:18862410), but they were not encountered.
The error has been repaired.
Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The next pointer of (1:51493948) refers to page (1:13991363). Neither (1:13991363) nor its parent were encountered. Possible bad chain linkage.
The error has been repaired.
Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The next pointer of (1:25557101) refers to page (1:14001554). Neither (1:14001554) nor its parent were encountered. Possible bad chain linkage.
The error has been repaired.
Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The next pointer of (1:25621531) refers to page (1:14007034). Neither (1:14007034) nor its parent were encountered. Possible bad chain linkage.
The error has been repaired.
Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The next pointer of (1:54782929) refers to page (1:14017699). Neither (1:14017699) nor its parent were encountered. Possible bad chain linkage.
The error has been repaired.
Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The next pointer of (1:28736425) refers to page (1:14017977). Neither (1:14017977) nor its parent were encountered. Possible bad chain linkage.
The error has been repaired.
Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Index node page (1:2573139), slot 0 refers to child page (1:14024996) and previous child (0:1), but they were not encountered.
The error has been repaired.
Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Parent node for page (1:17445388) was not encountered.
The error has been repaired.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The previous link (1:25712795) on page (1:17626858) does not match the previous page (1:13987932) that the parent (1:606814), slot 56 expects for this page.
The error has been repaired.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). The previous link (1:72767203) on page (1:19550681) does not match the previous page (1:16206464) that the parent (1:19914729), slot 38 expects for this page.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:19550681) is missing a reference from previous page (1:72767203). Possible chain linkage problem.
The error has been repaired.
Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Parent node for page (1:25712795) was not encountered.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:25716398) is missing a reference from previous page (1:51493948). Possible chain linkage problem.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:25736481) is missing a reference from previous page (1:25558176). Possible chain linkage problem.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:25742947) is missing a reference from previous page (1:25621531). Possible chain linkage problem.
The error has been repaired.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). B-tree chain linkage mismatch. (1:16206464)->next = (1:29140793), but (1:29140793)->Prev = (1:83488069).
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:88874051) is missing a reference from previous page (1:54782929). Possible chain linkage problem.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 484196775, index ID 1, partition ID 72057594145931264, alloc unit ID 72057594201899008 (type In-row data). Page (1:89030784) is missing a reference from previous page (1:25557314). Possible chain linkage problem.
The error has been repaired.
There are 247942019 rows in 45819868 pages for object "tbl_user_location_history".
CHECKDB found 0 allocation errors and 18 consistency errors in table 'tbl_user_location_history' (object ID 484196775).

CHECKDB fixed 0 allocation errors and 18 consistency errors in table 'tbl_user_location_history' (object ID 484196775).

databasedbcc
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.