Checkpoint Method (SQL-DMO)

The Checkpoint method forces a write of dirty database pages.

Applies To

Syntax

object.Checkpoint()

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

On a Microsoft® SQL Server™ installation, 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 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.

Prototype (C/C++)

HRESULT Checkpoint();