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

  • August 21, 2014 at 12:49 am

    #1739779

    copper_sunflower (8/20/2014)

    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.

    No, please no. We don't yet know exactly what's wrong, posting any kind of fix when we don't know the actual damage is irresponsible.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass