• Ah, well no page restores in simple recovery.

    So the table can be completely recreated from another source? If so, then just run checkDB with repair and then sync up the missing data (3 pages of data will disappear in the repair). You can sync manually or get something like RedGate's SQLDataCompare to do it for you.

    You also need to investigate the cause. It looks like a section on disk (24kb, which is a weird amount) has been zeroed out by something, likely some misbehaviour somewhere in the IO subsystem

    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