LiteSpeed for SQL Server 8.9 - User Guide

Log Reader - Full log

The Full Log page displays all records in the transaction log, including those that do not involve DML/DDL statements.

To view all records in the transaction log

1. Run the Read Log Wizard. For more information, see Read Transaction Logs.
2. Select the Full Log page in the Log Reader window. Log Reader displays the following information about the log entries on this page:
   • LSN (log sequence number) of the record
   • Function or operation executed
   • Context in which the operation executed
   • Database object affected by the function
   • Timestamp for the log record
   • Transaction ID generated for this log record

3. Navigate through and organize the log record entries to help you locate the information you need to review. Use any of these methods:

   • Navigate through the log entries using the navigation bar at the bottom of the list.
   • Sort the list in ascending order by a specific column by clicking the column heading. Click the column heading again to reverse the sort order.
   • Group like entries in the list. See Group Entries for more information.
   • Filter entries. For more information, see Filter Entries.
   • Find entries. See Find Entries for more information.

4. Select a specific entry to view additional information:

   Tab	Description
   Record Info	Information found in the Log Reader header contains details about the record itself: Operation—The function or operation for which the record was generated. Context—The context in which the operation was executed. Current LSN—The unique log sequence number (LSN) identifying this record. Previous LSN—The LSN of the log record written just previously by the transaction to which the current operation belongs. If the current log record is the first one written by the transaction, this field shows 00000000:0000. Flag bits—One or more general flags pertaining to the log record. For a complete listing of possible log-record flags, see your Microsoft SQL Server documentation. Transaction ID—The unique identifier for the transaction within the log.
   User Info	Information on the user and application that generated the entry: SPID—The unique identifier of the process in which context the operation was executed. Application—The application that executed the operation. User Host—The host from which the user launched process execution. NT Domain—The user domain. NT User—The domain user name. SQL Login—The SQL login used to execute the operation. Note: The Log Reader can collect NT User, SQL Login, User Host, and Application information for transactions started only when it is connected to the server.
   Record Data	Information about the table record whose data was affected by the function (command) as recorded in the log record, including: Name of each column in the table row. Data type for that column. Value (Old Value) in that column before the function executed. Value (New Value) in that column after the function executed.

Related Topics

Analyze Transaction Logs

Read Transaction Logs