Database with many Torn Pages RRS feed

  • Question

  • Hi there,

    We have a client who has no backups of their databases and has been suffering many errors with the following message:

    SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xffffffff: actual singnature 0x8e5f657).  It occurred during a read of page (1:495498) in database ID 12 at offest {} in file {*.mdf}

    Can anyone help me restore this database?

    Friday, June 25, 2010 9:06 PM


  • Thanks to all for the responses - We have raised an issue with MS and they have not been able to recover the databases because the mdf and ldf files are too corrupt.

    We are now re-deploying the solution that used the database and the client has learnt a VERY painful lesson which I am confident they will not repeat.  We will also be writing tools for them and all of our other clients to ensure that none of them are vulnerable to a failure as catastrophic as this has been for our client.

    Again thanks to all who resonded.

    • Marked as answer by Al Eardley Thursday, July 1, 2010 9:10 PM
    Thursday, July 1, 2010 9:10 PM

All replies