• The transaction log records aren't committed to data pages. The data modification is made to the data pages (in memory) and then logged into the transaction log. The only time you get replay from the log is in database recovery or restores (or on the mirror DB in database mirroring).

    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