CHECKPOINT statement

Description

Checkpoints the database.

Syntax

CHECKPOINT

Usage

CHECKPOINT 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 CHECKPOINT. For a full description of checkpoints, see Chapter 12, “Data Backup, Recovery, and Archiving,” in the System Administration Guide: Volume 1.

Side effects

None.

Standards

SQL92 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.