Basit s SQL Server Tips It is all about passion Main menu Skip to content Home SQL Server Tips SQL Server Performance Tips SQL Server 2012 SQL Server 2014 SQL Scripts Encryption Publications About Me Search GO RSS Feed Twitter Facebook JanuAn Overview on SQL Server Checkpoints Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure Checkpoints are part of such recovery mechanism SQL Server Database Engine is programmed to perform changes or modifications to database pages in buffer cache memory first and after some processing the modification are written on the disk files This â processingâ involves Checkpoint which writes all the dirty pages existing on Buffer Cache to Physical disk It also enters log records from buffer log to physical file Checkpoint in SQL Server was introduced to reduce the time required for recovery during an unexpected shutdown or system failure Database Engine issues a checkpoint for each database on regular intervals Various factors and conditions depending upon the Recovery Interval settings done commit a checkpoint to issue It can be an execution of ALTER DATABASE command manual execution of CHECKPOINT Server clean shutdown or even in case SQL database is in SIMPLE mode and its log is 70 full Talking about Checkpoints a regular definition states that once a transaction is made checkpoint writes about it But this is not true.