Manually Requesting a Checkpoint

Database owners can issue the checkpoint command to force all modified pages that are in memory to be written to disk.

Manual checkpoints do not truncate the log, even if the trunc log on chkpt option of sp_dboption is turned on.

Use the checkpoint command:

You can use checkpoint to identify one or more databases or use an all clause, which checkpoints all databases. See the Reference Manual: Commands.