A checkpoint is a point in the transaction log sequence at which
all data files have been updated to reflect the information in the log. All
data files will be flushed to disk. Refer to for more details about what
happens during a checkpoint.
The CHECKPOINT command forces an
immediate checkpoint when the command is issued, without waiting for a regular
checkpoint scheduled by the system (controlled by the settings in Checkpoints not intended for use during normal operation.
If executed during recovery, the CHECKPOINT command will force a restart point rather than writing a new
checkpoint.
Only super users can call CHECKPOINT.
