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.
With the Log Reader, you can view the following transaction types:
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.
For more information, see Export Results.
For more information, see View Table History.
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.
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.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
