Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

recovery_time option

Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.

Allowed values

Integer, in minutes



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes, with SET ANY SYSTEM OPTION No No

You may need to restart the database server for changes to this option setting to take effect.

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

The database server 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.