An inconsistency was detected

Am running asp.net application.Am searching records.if i click the view button i got this error,


an inconsistency was detected during an internal operation in
database(database name) on page(some page).please contact technical
support.reference number 6.

I Googled and i got the result as to run DBCC CHECKDB.
I run the following command in sql server 2005,

DBCC CHECKDB (database name) WITH NO_INFOMSGS, ALL_ERRORMSGS

my result was something like this


Table error: Object ID 1424372489, index ID 1, partition ID 374822652149760, alloc unit ID 93347675439104 (type In-row data). Page (1:72872) is missing a reference from previous page (1:72871). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 1


Object ID 1424372489, index ID 1, partition ID 374822652149760, alloc unit ID 93347675439104 (type In-row data): Page (1:109577) could not be processed. See other errors for details.
Msg 8978, Level 16, State 1, Line 1


Table error: Object ID 1424372489, index ID 1, partition ID 374822652149760, alloc unit ID 93347675439104 (type In-row data). Page (1:109578) is missing a reference from previous page (1:109577). Possible chain linkage problem.
Msg 8976, Level 16, State 1, Line 1


CHECKDB found 0 allocation errors and 10 consistency errors in table 'some table' (object ID 1424372489).


CHECKDB found 0 allocation errors and 5 consistency errors in table 'some table' (object ID 1432300808).


CHECKDB found 0 allocation errors and 19 consistency errors in database 'database name'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (database name).

Like Jeni said, you can run that command and it will do a repair, but CAN make it loose some data.

I would first start with:


DBCC CHECKDB('DB Name',REPAIR_REBUILD)

If that fails use the command provided by jeni:


dbcc checkdb(database name.repair_allow_data_loss)

But if you have to run with allow repair, consider restoring from backup.

StackExchange Database Administrators Q#11235, answer score: 2