SQL 2008 server logical consistency error

dhananjayv

Hi,
In NAV 2009 Classic and SQL 2008
While doing test for value entry table system showing follwoing error:-
" 824,SQL server detected a logical consistency- I/O based error; incorrect checksum (expected: 0X54b7003a:actual 0X54b70032) It occured during the read of page(3:555295) in database ID 8"

So guys let me know how to resolve this error....
please provide solution ASAP.

thanks well in advance

rgds
dhananjay

Shedman

A quick Google turned up http://msdn.microsoft.com/en-us/library/aa337274.aspx

Explanation:
This error indicates that Windows reports that the page is successfully read from disk, but SQL Server has discovered something wrong with the page. This error is similar to error 823 except that Windows did not detect the error. This usually indicates a problem in the I/O subsystem, such as a failing disk drive, disk firmware problems, faulty device driver, and so on.

So check your hardware and try to restore the broken page from your backup.

dhananjayv

how to restore the back up of broken pages?
I have list of broken pages

rgds
dhananjay

kine

You need to restore whole backup, not only backup of some pages...

bbrown

If it's only a few pages, a page restore can be faster. But if more then a few, you're likely better off just restoring the full DB.