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.