CHECKPOINT statement

Description

Checkpoints 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. Applications do not normally need to issue the CHECKPOINT statement. For a full description of checkpoints, see Chapter 14, “Backup and Data Recovery” in the Sybase IQ System Administration Guide.

Side effects

None.

Standards

SQL/92 Vendor extension

Sybase Supported by Adaptive Server Enterprise.

Permissions

Must have DBA authority to checkpoint the network database server. No permissions are required to checkpoint the personal database server.