Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 NOOB DB ADMIN in the worst position.
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

beezie
Starting Member

1 Posts

Posted - 12/21/2014 :  11:23:45  Show Profile  Reply with Quote
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 1
Unable to read and latch page (1:1379395) with latch type SH. 1(Incorrect function.) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1379938) with latch type SH. 1(Incorrect function.) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1379954) with latch type SH. 1(Incorrect function.) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1380221) with latch type SH. 1(Incorrect function.) failed.
Msg 8966, Level 16, State 2, Line 1
Unable 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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 1
Table 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).

gbritton
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 12/21/2014 :  16:18:48  Show Profile  Reply with Quote
hope you have a backup
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000