What is a checkpoint?

A checkpoint writes dirty data pages for a database from memory to disk as part of SQL Server's recovery and buffer-management process.

Checkpoints help limit the amount of work required during crash recovery. They do not mean every transaction log record can immediately be discarded; log truncation depends on recovery model and other factors that can prevent log reuse.

SQL Server supports automatic, manual, indirect, and internal checkpoint behavior depending on configuration and circumstances.