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

  • 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.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.