Documentation / Log Reader / Common Workflows

Common Workflows

Practical recovery and audit scenarios with Log Reader.

Undo an accidental DELETE / UPDATE

  1. Connect and select the database (FULL recovery recommended for online log).
  2. Narrow filters to the table and approximate time window.
  3. On Log Entries, find the offending operations; open Data Changes if you need before/after values.
  4. Generate Undo scripts for the selected rows; review in SSMS on a copy first when possible.
  5. For multi-statement accidents, use the Transactions or Recovery tab for transaction-scoped undo/redo.

Point-in-time recovery script

  1. Open the Recovery tab and set the target point in time.
  2. Choose undo vs redo direction based on whether you need to reverse or re-apply work.
  3. Export the script; execute under change control after backup verification.

Audit who changed a row

  1. Use Row History / filters for the table and key.
  2. Walk the timeline of INSERT/UPDATE/DELETE entries and export for the ticket.