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

  • Your database test.mdf is corrupt. If you have a backup, then just restore with that backup. If you don't, then you may use REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS parameters in DBCC CHeckdb to try to fix the corruption. Note you must make a backup of your current Test.mdf before calling these parameters.

    There are also some online resources discussing about this situation, for example:

    http://www.datanumen.com/sql-recovery/problems/checkdb-checktable-fail.htm

    Good luck!