Checkpointing Databases

Use the checkpoint command to force Adaptive Server to write modified data pages from memory to disk.

When you issue a checkpoint, Adaptive Server freezes all current data-modifying transactions while writing to the disk. See the Adaptive Server Reference Manual: Commands.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • Archive Databases
    • In-Memory Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database.
  4. Click on the arrow and select Checkpoint.
  5. Confirm that you want to run checkpoint on the current database.
Related tasks
Checking Database Consistency