Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw An examination of bulk-logged recovery model RE: An examination of bulk-logged recovery model

  • May 8, 2012 at 6:07 am

    #1484451

    Ewald Cress (5/8/2012)

    I thought I had a decent grasp of logging issues, but I must admit that I had a light-bulb moment when you described the Eager Write mechanism!

    Please note that Eager Writes are just for minimally logged operations in bulk-logged or simple recovery, and they just write the minimally logged pages to the data file.

    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