Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shuli
Starting Member
1 Post |
 Posted - 2007-11-22 : 03:09:23
|
I ran the checkdb, and got these results  :Msg 8966, Level 16, State 2, Line 1 Unable to read and latch page (1:10267) with latch type SH. 23(Data error (cyclic redundancy check).) failed. Msg 2533, Level 16, State 1, Line 1Table error: page (1:10267) allocated to object ID 1815833681, index ID 8, partition ID 2370802289803264, alloc unit ID 2370802289803264 (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 1815833681, index ID 8, partition ID 2370802289803264, alloc unit ID 2370802289803264 (type In-row data). Page (1:10267) was not seen in the scan although its parent (1:6350) and previous (1:15517) refer to it. Check any previous errors.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 1815833681, index ID 8, partition ID 2370802289803264, alloc unit ID 2370802289803264 (type In-row data). Page (1:15518) is missing a reference from previous page (1:10267). Possible chain linkage problem.There are 93755 rows in 4415 pages for object "TransactionEntry".Please Help!!!! it's a customers DB, and I don't know what to do.... ShuliDeveloper Team Leader |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 16:30:20
|
| I'll take backup of the db, restore it with new db name, rebuild indexes on that table then run dbcc checkdb again. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-23 : 21:52:31
|
quote:
Originally posted by shuli
Please Help!!!! it's a customers DB, and I don't know what to do....
Open a case with Microsoft if you don't have DBA-level experience. It is not worth it to lose a customer when it doesn't cost much to get help from MS.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Msg 8966, 2533, 8976,8978 - if you can understand@