Chat now with support
Chat with Support

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...



    Check log file changes every

    Check the log file for changes every so many seconds.

    10 seconds

    Show uncommitted transactions

    List all the transactions that are not committed.


    Reconstruct DDL commands

    Select this option to display both DML and DDL commands


    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


    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.


    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.



Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating