Checkpoints in Transaction Log in Microsoft SQL Server

Checkpoints are created in a transaction log When :

1. Checkpoint is explicitly executed.
2. Logged operation is performed on the database.
3. Database files have been altered using Alter Database command.
4. Microsoft SQL Server has been stopped explicitly or on its own.
5. Microsoft SQL Server periodically generates checkpoints.
6. Backup of a database is taken.

See Also