다음을 통해 공유

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