Post reply

Torn Page issue

  • May 17, 2010 at 12:21 pm

    #386943

    Early last week experienced NTFS corruption which resulted in a couple of torn pages as evidenced by DBCC checkdb. I have the tried page level restores without success since a vendor tried to take a tail end Tlog backup and never took the system offline. End result the transaction log chain is broken so we can't restore using a post corruption backup.

    But my actual question is this, I have the two pages in question can I determine the database objects that rest on those pages. The database contains one table with two columns(unique ID, TEXT).

  • May 21, 2010 at 11:36 am

    #1171003

    Chris Mathews (5/17/2010)

    But my actual question is this, I have the two pages in question can I determine the database objects that rest on those pages. The database contains one table with two columns(unique ID, TEXT).

    Only if you can read the headers of those pages and the headers are intact. Depends on how bad the damage is.

    Try

    DBCC TRACEON(3604)

    DBCC Page(<database id>, <file id>, <Page Number>

    DBCC TRACEOFF(3604)

    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

  • May 21, 2010 at 11:46 am

    #1171008

    Thanks, we created a new blank database and copied all the good records across (2 bad records) and caught the offending records object IDs in a try..catch loop.

    Now that we have those IDs in a separate table, we restored to a known good backup and insert..select from to copy those records in the new database.

    Voila.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply