|
Parameter
|
Description
|
For more information, see
|
|
-lgTruncateFrequency
|
Specify the frequency of when your log file is truncated. Valid values include daily, one day per week, or the last day of the month. Must be used with -lgTruncateTime.
|
|
|
-lgTruncateTime
|
Specify the time of day when your log file is truncated. Valid values are based on a twenty four hour clock, 00:00 (midnight) to 23:59 (one minute before midnight). Must be used with -lgTruncateFrequency.
Note: If the database is offline or in single user mode when the time and frequency parameters indicate, no truncation occurs until the next time the parameters are satisfied.
|
|
|
-lgTruncateSize
|
Specify the size in MB when the database log file is to be truncated. Valid values range from 0 to 2147483647. The value of 0 (default) indicates that truncation based on size is disabled.
Note: If the database is in single user mode when the log file reaches the specified size, it is not truncated. It is truncated the next time the database is brought online in multi-user mode, provided the size criterion is still met. If the log file reaches the specified size while writing a message, the database log file is truncated at the conclusion of writing the message.
|
|
Parameter
|
Description
|
For more information, see
|
|
-lgArchiveEnable
|
Specify that you want the database log file archived before truncating it.
Note: If archiving the log file fails for any reason, the log file is not truncated.
|
|
|
-lgArchiveDir
|
Specify the fully qualified path name of the directory where you want the archive files written.
|