Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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).

share|improve this question

migrated from stackoverflow.com Jan 21 '12 at 23:28

This question came from our site for professional and enthusiast programmers.

    
Are you accessing a database and what kind of database is it? –  Jarrett Widman Mar 16 '11 at 4:49
    
so is still there is an problem? –  Bhavik Goyal Mar 16 '11 at 6:17

2 Answers 2

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.

share|improve this answer
    
Yes U r right . I got failed with that command and then tried the repair with data loss command. –  jeni Mar 21 '11 at 11:23
up vote 1 down vote accepted

This inconsistency error can be resolved by running the following command:

dbcc checkdb(database name,repair_allow_data_loss)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.