June 19, 2008 at 3:17 am
I am having these errors while I run DBCC CHECKDB ( myDB )
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:2542368) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2020202247, index ID 1, partition ID 72057594145669120, alloc unit ID 72057594087800832 (type LOB data). The off-row data node at page (1:2444050), slot 0, text ID 901891555328 is not referenced.
I have already executed dbcc dbreindex(myTable) successfully, but I'm still having errors.
please comment.
June 19, 2008 at 2:38 pm
This seems to be a system table
and leaf page corruption in a clustered index..
check out other Posts i have posted some links from PAUL RANDAL, the checkdb Guru and SQL Server Engine Advice ...
Maninder
www.dbanation.com
June 19, 2008 at 2:48 pm
Duplicate post - reference here:
http://www.sqlservercentral.com/Forums/Topic519683-266-1.aspx
-- You can't be late until you show up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply