Home Forums SQL Server 2008 T-SQL (SS2K8) Need Minimally Logged Operation to Cause Checkpoint! RE: Need Minimally Logged Operation to Cause Checkpoint!

  • April 5, 2013 at 2:17 pm

    #1604125

    ScottPletcher (4/5/2013)

    GilaMonster (4/5/2013)

    Any data modification that is minimally logged has to be written to the data file before the transaction completes

    I don't think that's true. If it is, it violates the write-ahead-logging model, which SQL Server uses; only log records should have to be hardened for a transaction to complete, not data blocks.

    I'll go with Gail on this one having reread this article: http://www.sqlservercentral.com/articles/Recovery+Model/89664/.