Collection Contents Index -gp server option Next PDF

SQL Anywhere® Server - Database Administration  > The Database Server  > The SQL Anywhere database server  > Database server options

-gr server option


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

Syntax

{ dbsrv10 | dbeng10 } -gr integer ...

Applies to

All operating systems and servers.

Remarks

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

Collection Contents Index -gp server option Next PDF