Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Log Reader - Analyze Transaction Logs

The Log Reader is a log analysis and data-recovery tool that reads the SQL Server transaction logs for databases to display information about changes to data and objects.

View Transactions

With the Log Reader, you can view the following transaction types:

  • Recent transactions (those held in memory since the SQL Server instance was started).
  • Full database log (includes all transactions stored in the transaction log of an active database as well as transactions held in SQL Server memory).

    Note: To view the transaction log of an active database, such as on the Full Log page, make sure the Log Reader server components are installed on the SQL Server instance hosting the database. For more information, see Install Log Reader Server Components.

  • All transactions stored in the full-backup file for the database.

Group, Filer and Export Log Entries

For more information, see Export Results.

View Table History

For more information, see View Table History.

Generate DDL/DML Statements

Generate T-SQL statements to undo or redo a DML/DDL SQL statement executed on the database. You can then apply the undo or redo statement using the Undo/Redo wizard. For more information, see DML/DDL Page.

Recover Tables

Recreate a table in the database and reload data that, as recorded in the transaction log, was dropped or truncated. For more information, see Recover Tables.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating