I have a sql express (2005) database running through a 3rd party windows application. The application appears to be encountering errors and has started to 'drop-out.' I've run dbcc checkdb (which is about as far as my knowledge extends on db errors)
and get the following errors (all other tables are ok);
I checked recent backups and they all have the same problem, so I can't just restore. Can anyone guide me how I can fix this?
.........................................
DBCC results for 'ActivityTrackingHistory'.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 85575343, index ID 3, partition ID 72057594038910976, alloc unit ID 72057594043891712 (type In-row data). Page (1:3126) is missing a reference from previous page (1:3972). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 1
Object ID 85575343, index ID 3, partition I ...
Go to the complete details ...