SQL 2008 server logical consistency error

dhananjayv
dhananjayv Member Posts: 55
edited 2010-11-17 in NAV Three Tier
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

Comments

  • Shedman
    Shedman Member Posts: 194
    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
    dhananjayv Member Posts: 55
    how to restore the back up of broken pages?
    I have list of broken pages

    rgds
    dhananjay
  • kine
    kine Member Posts: 12,562
    You need to restore whole backup, not only backup of some pages...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bbrown
    bbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.

Categories