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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options


-gr server option

Sets the maximum length of time (in minutes) for recovery from system failure.

{ dbsrv11 | dbeng11 } -gr minutes ...
Applies to

All operating systems and database servers.


When a database server is running with multiple databases, the recovery time that is specified by the first database started is used unless overridden by this option.

The value specified by the -gr option instructs the database server how often to perform a checkpoint. For example, if you set -gr to 5, then the database sever tries to perform checkpoints often enough so that recovery takes no longer than 5 minutes. However, if recovery is necessary, it runs to completion, even if it takes longer than the length of time specified by -gr. The default value is the setting of the recovery_time database option, which defaults to 2 minutes.

The recovery time includes both the estimated recovery time and the estimated checkpoint time for the database.

See also