Solved

How to correct error in Sql Server:  An inconsistency was detected during an internal operation in database 'Nawada'(ID:6) on page (1:14194556). Please contact technical support. Reference number 4.

Posted on 2010-11-16
10
796 Views
Last Modified: 2012-05-10
I have a database Nawada, and Table name is txndependents
for which i am not able to fetch record because of above error.
The output of dbcc checkdb is as follows: This has stuck my work, Please help, so that i can correct the error.

DBCC results for 'TxnDependents'.
Msg 8928, Level 16, State 1, Line 1
Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data): Page (1:14194556) could not be processed.  See other errors for details.
Msg 8944, Level 16, State 18, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data), page (1:14194556), row 0. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 25 and 67.
Msg 8944, Level 16, State 18, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data), page (1:14194556), row 0. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 25 and 67.
There are 24621219 rows in 320099 pages for object "TxnDependents".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'TxnDependents' (object ID 1093578934).
0
Comment
Question by:searchsanjaysharma
  • 5
  • 3
  • 2
10 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34145197
Rebuild your Primary key or Clustered key in txndependents table which should ideally fix consistency issues.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34145205
Can you check to see if you have full & transaction log backups?

DONT RESTORE YET, this is a check.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34145224
@rrjegan if you have a corrupted clustered index you cannot just rebuild it as this is the leaf level data! Although i do agree that you can rebuild non-clustered indexes.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34145339
searchsanjeysharma,

Could you tell me if anything has happened recently to the system? Disk failure / Power Failure etc?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 34145555
>> @rrjegan if you have a corrupted clustered index you cannot just rebuild it

Yes, if rebuilding can't be done, then we need to do

DBCC CHECKTABLE (TxnDependents, REPAIR_REBUILD );

and if it is not fixed, then we need to do (This might cause some loss in corrupted data.)

DBCC CHECKTABLE (TxnDependents, REPAIR_ALLOW_DATA_LOSS );
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34145606
As you say replair allow data loss could loose data so the better option would be to do a tail log backup to ensure you have to most recent transactions and take the database offline so nothing more can go into the database. Then.....

restore full backup in norecovery
apply all the transaction log backups including the tail log backup which has been taken.

This will mean there is no data loss. But obviously this is dependant upon if the backups are available. Thus the original response.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34145647
If there is any data loss, then you can try restoring from the available backups as mentioned by you..
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34145838
Repair will not cause data loss? It depends. If you have to use REPAIR_ALLOW_DATA_LOSS, then you're going to lose data. That's why the option is named that - seriously

Quote from Paul Randall
http://www.sqlskills.com/aboutpaulsrandal.asp
0
 

Author Comment

by:searchsanjaysharma
ID: 34371646
ok
0
 

Author Closing Comment

by:searchsanjaysharma
ID: 37767140
ok
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now