LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Log Reader - Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set the Log Reader options

1. Select the Application Button and select Options (Keyboard: ALT+F+O).
2. Select the Log Reader tab.

3. Review the following for additional information:

   Use this option...	To...	Default
   Check log file changes every	Check the log file for changes every so many seconds.	Selected 10 seconds
   Show uncommitted transactions	List all the transactions that are not committed.	Selected
   Reconstruct DDL commands	Select this option to display both DML and DDL commands	Selected
   Export all details of the log	Export all details of the log file. TIP: Select this option to get a full report.	Not Selected
   Online log reading timeout	Set the amount of time the log is read before a timeout is reached.	300 seconds
   Maximum BLOB size	Set the maximum Binary Large Object (Blob) Data size.	8000 bytes
   Reconstruction	Select one or both of the following: Request full database backup file if needed - When reading an online or offline log, the Log Reader might need to refer to the full-backup file for the database to reconstruct old log records. Select this option to enable the use of the full-backup file. Enclose Undo/Redo scripts in a transaction - Use this option to turn on or off transactions for undo/redo scripts. NOTE: You need to turn off transactions to undo or redo in-memory objects.	Selected
   Search Depth	Select whether to read the entire log file or only a set number of records in the log file. The options are: Read entire log file - Select this option to read the entire log file. Read approximately - Select this option to set the number of records to read. NOTE: The minimum number of records to read is 100,000. The Log Reader stores temp data in %temp%/Quest Software where %temp% is the first path found of: the path specified by the TMP environment variable, the path specified by the TEMP environment variable, the path specified by the USERPROFILE environment variable, the Windows temp directory.	100000

Related Topics

Analyze Transaction Logs

Read Transaction Logs