Setting auditing configuration parameters  Truncating the transaction log

Chapter 18: Auditing

Setting up transaction log management

This section describes guidelines for managing the transaction log in sybsecurity.

If the trunc log on chkpt database option is active, Adaptive Server truncates syslogs every time it performs an automatic checkpoint. After auditing is installed, the value of trunc log on chkpt is on, but you can use sp_dboption to change its value.





Copyright © 2005. Sybase Inc. All rights reserved. Truncating the transaction log

View this book as PDF