The Checkpoint method forces a write of dirty database pages.
object.Checkpoint( )
object
Expression that evaluates to an object in the Applies To list
HRESULT Checkpoint();
For an instance of Microsoft® SQL Server™2000, database checkpoints are performed automatically and at user direction. Checkpoints verify the consistency of data and a database can be configured for log truncation on a checkpoint, as consistency is assumed when a checkpoint occurs. For more information about SQL-DMO and checkpoints, see TruncateLogOnCheckpoint Property and ConfigValue Object.
For more information about SQL Server database checkpoints, see CHECKPOINT and recovery interval Option.