Hello,

Had a recent drive failure on or server. Subsequently Our sql database failed to backup. Ran dbcc checkdb and got the following errors:

I am a novice at SQL. Grateful for some insight into how to fix these errors.

Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:241724) with latch type SH. 1(Incorrect function.) failed. 

Msg 2533, Level 16, State 1, Line 1
Table error: page (1:241724) allocated to object ID 370100359, index ID 3, partition ID 868679827259392, alloc unit ID 868679827259392 (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 370100359, index ID 3, partition ID 868679827259392, alloc unit ID 868679827259392 (type In-row data). Page (1:241724) was not seen in the scan although its parent (1:241044) and previous (1:241723) refer to it. Check any previous errors.

Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 370100359, index ID 3, partition ID 868679827259392, alloc unit ID 868679827259392 (type In-row data). Page (1:242042) is missing a reference from previous page (1:241724). Possible chain linkage problem.

regards

Clement

This looks as though there are missing and/or incomplete memory pages.

You could try rebuilding the indexes and see if that fixes the issue; if not you will have to go back to a previous backup set.

How big is the database if it is small enough I mean 20-60 G or size which can be restored within acceptable time I would suggest restoring from valid backup to recover from corruption

Other thing, what did dbcc checkdb suggested in last part of output, i guess it would have suggested some repair option

IndexID=3 is NON clustered index and corruption might get fixed if you drop and recre

Really?  You propose to a NOVICE to use undocumented dbcc commands. 

And you aren't new.  There is a way to post links that makes them clickable.  Please try to use that method.

Thank you.

I researched but then reached out to an expert for assistance in actually executing .

Much obliged!