The Checkpoint statement ensures that all database changes in memory are committed to disk. Executing the Checkpoint statement closes the database files, rewrites the script file, deletes the log file, and reopens the database.
Syntax
CHECKPOINT [DEFRAG]
Notes
If DEFRAG is specified, this statement evaluates abandoned space in the database data (.data) file and shrinks the data file to its minimum size.
If DEFRAG is specified, this statement evaluates abandoned space in the database data (.data) file and shrinks the data file to its minimum size.