Home Forums SQL Server 2005 Data Corruption How to apply transaction log from physical file to restored DB? RE: How to apply transaction log from physical file to restored DB?

  • Maybe possible, maybe not.

    You'll need to hack the database back into the server (google for hack attach Paul Randal)

    Then, if that's successful, you'll need to see if you can take a tail log backup. Requires that the database was in full recovery with an unbroken log chain at the time of the disaster.

    Then you'll probably have to restore the database again, leaving it in the RECOVERING state, then apply all log backups that were taken between when the full backup you used was taken and the time of the disaster. If any are missing or if there was any break in the log chain you won't be able to restore.

    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