Home Forums SQL Server 2005 Data Corruption Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:16514; actual 0:0). It occurred during a read of page (1:16514) in database ID 8 at offset 0x00000008104000 in file 'G:\test\test.mdf'. Additional messages in the SQL Server RE: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:16514; actual 0:0). It occurred during a read of page (1:16514) in database ID 8 at offset 0x00000008104000 in file 'G:\test\test.mdf'. Additional messages in the SQL Serve

  • September 8, 2014 at 7:01 am

    #1743847

    As the main reason of SQL error 823 is page level corruption. Basically SQL Server performs its I/O operation through API if he finds check fails then immediately it reports an error. So I recommend you to check the hardware first.

    SSMS Expert