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 |
|
sasan.kh
Starting Member
23 Posts |
 Posted - 2009-07-28 : 07:50:08
|
| Hi allUsing sql server 2000 and sp4, there is a high record table(with multiple indexes) with frequent consistency errors. Usually these errors are repaired by recreating indexes. But always there is a consistency error not associated with any object. How can I find the problem?>DBCC CHECKTABLE("spJavab_Az")Server: Msg 8960, Level 16, State 1, Line 1Table error: Page (1:150979), slot 62, column 3 is not a valid complex column.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 1435079, Index ID 12. Keys out of order on page (1:18129), slots 307 and 308.CHECKTABLE found 0 allocation errors and 1 consistency errors not associated with any single object.DBCC results for 'spJavab_Az'.There are 2574639 rows in 29911 pages for object 'spJavab_Az'.CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'spJavab_Az' (object ID 1435079).repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (dbSina.dbo.spJavab_Az ). |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
|
|
|
DBCC Checktable error