Integer, in minutes

2

Can only be set for PUBLIC. You must have the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect when the database server is restarted.

This option is used with the checkpoint_time option to decide when checkpoints should be done.

SQL Anywhere uses a heuristic to estimate the recovery time based on the operations that have been performed since the last checkpoint, and includes both the estimated recovery time and the estimated checkpoint time for the database. So, the recovery time is not exact.

• The automatic recovery process
• checkpoint_time option
• -gr database server option
• How the database server decides when to checkpoint
• recovery_time connection property