We are having some troubles with corrupt indexes on our SQL 2000
dbase.
It is only affecting 2 tables out of about 150 we have.
These 2 tables are heavily used.
We have run dbcc repairs; dropped and recreated indexes but the
problem persists
Is it possible that this ongoing problem is indicative of a hardware
problem.
If so how could we diagnose this?
here is a sample of the dbcc check against one of the tables whose
indexes we are having trouble with:
thanks
J.C. Clay
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_sessionid' (ID 7) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (session_id = B89F855E-CBB7-4874-A3BD-8D8827ED1481@§_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_nav' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (navigation_id = A9E17BF3-41A6-43EF-8FD6-15C5B5E5E744@§_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_tab_nav' (ID 10) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (tab_navigation_id =
6373D50E-EF0B-4084-B8A7-032653E262E2@§_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_view_id' (ID 11) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (page_view_id = 431E5427-A688-4957-967B-A3466799D94E@§_).
DBCC results for 'page_views'.
There are 958422 rows in 54595 pages for object 'page_views'.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table
'page_views' (object ID 1436024347).
repair_fast is the minimum repair level for the errors found by DBCC
CHECKTABLE (profound.dbo.page_views ).