Use this statement to checkpoint the database.
The CHECKPOINT statement forces the database server to execute a checkpoint. Checkpoints are also performed automatically by the database server according to an internal algorithm. It is not normally required for applications to issue the CHECKPOINT statement.
DBA authority is required to checkpoint the network database server.
No permissions are required to checkpoint the personal database server.
SQL/2003 Vendor extension.