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