ASA SQL Reference
  SQL Statements

CHECKPOINT statement

Description 

Use this statement to checkpoint the database.

Syntax 

CHECKPOINT

Usage 

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 issue the CHECKPOINT statement.

For a full description of checkpoints, see Backup and Data Recovery.

Permissions 

DBA authority is required to checkpoint the network database server.

No permissions are required to checkpoint the personal database server.

Side effects 

None.

See also 

CHECKPOINT_TIME option [database]

RECOVERY_TIME option [database]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Adaptive Server Enterprise.