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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-gp server option Next Page

-gr server option

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


{ dbsrv10 | dbeng10 } -gr integer ...

Applies to

All operating systems and 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 recovery time includes both the estimated recovery time and the estimated checkpoint time for the database.

See also