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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options


-on server option

Specifies a maximum size for the database server message log, after which the file is renamed with the extension .old and a new file is started.

{ dbsrv11 | dbeng11 } -on { size[ k | m | g ] } ...
Applies to

All operating systems and database servers.


The size is the maximum file size for the database server message log, in bytes. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes respectively. The minimum size limit is 10 KB. By default, there is no maximum size limit.

When the database server message log reaches the specified size, the database server renames the file with the extension .old, and starts a new file with the original name.


If the .old database server message log file already exists, it is overwritten. To avoid losing old database server message log files, use the -os option instead.

This option cannot be used with the -os option.

It is recommended that you do not end the database server message log file name with .log because this can create problems for utilities that perform operations using the transaction log.

See also