Controlling the Checkpoint Retention
The CHECKPOINTRETENTIONTIME
option of the
TRANLOGOPTIONS
parameter controls the number of days that
Extract retains checkpoints before purging them automatically.
Partial days can be specified using decimal values. For example, 8.25 specifies 8 days and 6 hours. The default is seven days.