CHECKPOINT statement

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.

You must have the CHECKPOINT system privilege to perform a checkpoint on a database running on a network server (dbsrv).

No privileges are required to perform a checkpoint on a database running on a personal database server (dbeng17).

None.

• ANSI/ISO SQL Standard

  Not in the standard.

• Transact-SQL

  The CHECKPOINT statement is supported by Adaptive Server Enterprise.