|
beezie
Starting Member
1 Post |
 Posted - 2014-12-21 : 11:23:45
|
| Please help me! I am not a DB admin, and I have been thrust into the role after taking a new job. I need as much step by step as you can give me...I've already done the dbcc checkdb(‘DB-NAME’,REPAIR_REBUILD) and the dbcc checkdb(‘DB-NAME’,REPAIR_ALLOW_DATA_LOSS) to no avail.I'm in a real pickle here.This is the dbcc checkdb(‘DB-NAME’) with no_infomsgs result. Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:1379395) with latch type SH. 1(Incorrect function.) failed.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:1379938) with latch type SH. 1(Incorrect function.) failed.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:1379954) with latch type SH. 1(Incorrect function.) failed.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:1380221) with latch type SH. 1(Incorrect function.) failed.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:1380237) with latch type SH. 1(Incorrect function.) failed.CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.Msg 2533, Level 16, State 1, Line 1Table error: page (1:1380237) allocated to object ID 1345738380, index ID 2, partition ID 72057603738501120, alloc unit ID 72057603729653760 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1345738380, index ID 2, partition ID 72057603738501120, alloc unit ID 72057603729653760 (type In-row data). Page (1:1380237) was not seen in the scan although its parent (1:822100) and previous (1:1380236) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1345738380, index ID 2, partition ID 72057603738501120, alloc unit ID 72057603729653760 (type In-row data). Page (1:1380238) is missing a reference from previous page (1:1380237). Possible chain linkage problem.CHECKDB found 0 allocation errors and 3 consistency errors in table 'ttfgld482500' (object ID 1345738380).Msg 2533, Level 16, State 1, Line 1Table error: page (1:1379395) allocated to object ID 1761739862, index ID 1, partition ID 72057603740991488, alloc unit ID 72057603732144128 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1761739862, index ID 1, partition ID 72057603740991488, alloc unit ID 72057603732144128 (type In-row data). Page (1:1379395) was not seen in the scan although its parent (1:2223267) and previous (1:1379394) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1761739862, index ID 1, partition ID 72057603740991488, alloc unit ID 72057603732144128 (type In-row data). Page (1:1379396) is missing a reference from previous page (1:1379395). Possible chain linkage problem.Msg 2533, Level 16, State 1, Line 1Table error: page (1:1380221) allocated to object ID 1761739862, index ID 9, partition ID 72057603741515776, alloc unit ID 72057603732668416 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1761739862, index ID 9, partition ID 72057603741515776, alloc unit ID 72057603732668416 (type In-row data). Page (1:1380221) was not seen in the scan although its parent (1:1402332) and previous (1:1380220) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1761739862, index ID 9, partition ID 72057603741515776, alloc unit ID 72057603732668416 (type In-row data). Page (1:1380222) is missing a reference from previous page (1:1380221). Possible chain linkage problem.CHECKDB found 0 allocation errors and 6 consistency errors in table 'ttfgld495500' (object ID 1761739862).Msg 2533, Level 16, State 1, Line 1Table error: page (1:1379954) allocated to object ID 1987172708, index ID 1, partition ID 72057604003069952, alloc unit ID 72057603994222592 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1987172708, index ID 1, partition ID 72057604003069952, alloc unit ID 72057603994222592 (type In-row data). Page (1:1379954) was not seen in the scan although its parent (1:7233319) and previous (1:1379953) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1987172708, index ID 1, partition ID 72057604003069952, alloc unit ID 72057603994222592 (type In-row data). Page (1:1379955) is missing a reference from previous page (1:1379954). Possible chain linkage problem.CHECKDB found 0 allocation errors and 3 consistency errors in table 'twhltc300500' (object ID 1987172708).Msg 2533, Level 16, State 1, Line 1Table error: page (1:1379938) allocated to object ID 2056692908, index ID 6, partition ID 72057603715563520, alloc unit ID 72057603706716160 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 2056692908, index ID 6, partition ID 72057603715563520, alloc unit ID 72057603706716160 (type In-row data). Page (1:1379938) was not seen in the scan although its parent (1:1014679) and previous (1:1379937) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 2056692908, index ID 6, partition ID 72057603715563520, alloc unit ID 72057603706716160 (type In-row data). Page (1:1379939) is missing a reference from previous page (1:1379938). Possible chain linkage problem.CHECKDB found 0 allocation errors and 3 consistency errors in table 'ttfgld106500' (object ID 2056692908).CHECKDB found 0 allocation errors and 20 consistency errors in database 'infordb'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (infordb). |
|
NOOB DB ADMIN in the worst position.