Limits the size of the request-level logging file.
-zs {size [ k | m | g ] }
Turn on request-level logging using the -zr switch, and redirect to a separate file using the -zo switch. You limit the size of the file using the -zs switch.
Size is the maximum file size for the request log, in bytes. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes, respectively.
When the request log file reaches the size specified by either the -zs option or the sa_server_option system procedure, the file is renamed with the extension .old appended (replacing an existing file with the same name if one exists). The request-level log file is then restarted.
If you specify -zs 0, then there is no maximum size for the request logging file, and the file is never renamed. This is the default value.
The following example shows how the -zs option is used to control log file size. Suppose you start a database server with the following options on the command line:
-zr all -zs 10 -zo mydatabase.log
A new log file mydatabase.log is created. When this file reaches 10K in size, any existing mydatabase.old files are deleted, mydatabase.log is renamed to mydatabase.old, and a new mydatabase.log file is started. This process is repeated each time the mydatabase.log file reaches 10K.