Sql error on viewing the table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xd88cd4d4; actual: 0xd88cdcd4). It occurred during a read of page (1:2963) in database ID 5 at offset 0x00000001726000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\MicroFinance.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Posted 21-Sep-13 20:04pm

User-10250592

Add a Solution

Comments

User-10250592 22-Sep-13 2:08am

I have runned the repair script but the problem is not solved.

ALTER DATABASE MicroFinance SET SINGLE_USER;
DBCC CHECKDB (MicroFinance, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;
ALTER DATABASE MicroFinance SET multi_USER;

User-10250592 23-Sep-13 1:12am

That database is of my friend and i has restored then the error came on my computer too as same error came to my friend. i has checked the system of my computer the computer is healthy so is there any idea to repair that table data.

phil.o 23-Sep-13 1:47am

What error messages are returned by the command DBCC CHECKDB (MicroFinance, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2013-09-21T20:30:00

If I were you, I would check for system event log ; you may have a problem with the hard drive hosting your C: partition.
If there are errors reported in there, you should check for the health of this drive from a command line:

chkdsk c: /r

and answer yes when it asks you whether you want to do it at next reboot. Then reboot and wait for the end of the process (which may take a long time if this partition is large and you have a lot of files in it).

If there are no errors with the partition, then I would try to backup the database, dropt it, and restore it back from the backup.

Hope this helps.