Do more with
A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk and, also, records information about the transaction log.(See https://docs.microsoft.com/en-US/sql/relational-databases/logs/database-checkpoints-sql-server)
A checkpoint is essential but not sufficient for truncating the log under the full recovery model or bulk-logged recovery model. After a checkpoint, the log remains intact at least until the next transaction log backup.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial