共用方式為

  • 發行項

Checkpoint Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。

The Checkpoint method forces a write of dirty database pages.

語法

object.Checkpoint( )

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

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 選項.

Applies to:

Database Object