index corruption issues

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 ).bigmuldoon@.yahoo.com (J. C. Clay) wrote in message news:<30005581.0307160848.68362af2@.posting.google.com>...
> 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 ).

It looks like you're using uniqueidentifier values, so you might be
seeing this issue:

http://support.microsoft.com/defaul...kb;en-us;284440

Simon