Export (0) Print
Expand All

Checkpoint Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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, 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 Distributed Management Objects (SQL-DMO) and checkpoints, see TruncateLogOnCheckpoint Property and ConfigValue Object.

For more information about SQL Server database checkpoints, see CHECKPOINT (Transact-SQL)and recovery interval Option.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft