Recovery & Forensics

Investigate SQL Server Changes. Recover Deleted Data.

Analyze SQL Server transaction logs to identify INSERT, UPDATE, DELETE, and schema changes. Inspect before-and-after values, investigate transactions, and generate Undo/Redo T-SQL scripts without restoring an entire database.

  • Analyze SQL Server transaction logs
  • Investigate deleted and modified records
  • Generate Undo/Redo recovery scripts

Transaction Log Analysis

Analyze online transaction logs and supported transaction log backup files.

Before-and-After Values

Inspect old and new column values for supported data modifications.

Recovery Script Generation

Generate Undo and Redo T-SQL scripts for supported operations.

Multiple Log Sources

Work with supported online database, .ldf, .bak, and .trn sources.

Log Reader Features

Built for SQL Server DBAs who need clear transaction log investigation, change analysis, and recovery script drafting.

Simplified Log Entries

Read online transaction logs and supported offline log files. Focus on meaningful INSERT, UPDATE, and DELETE operations without unnecessary internal log noise.

Sidebar Object Tree

Browse database schemas and tables with per-object change counts. Quickly locate objects affected during the selected log analysis window.

Schema & Truncate Events

Review CREATE, ALTER, DROP, and TRUNCATE operations in a separate view, keeping schema changes distinct from row-level DML activity.

Undo & Redo Scripts

Generate T-SQL scripts to reverse or replay supported row changes. Review the generated scripts before executing them in SQL Server Management Studio. See undo/redo limits.

Grid View

Inspect old and new column values for selected DML operations. Review the changes before generating Undo or Redo scripts.

Point-in-Time Recovery

Generate recovery SQL for a selected table and timestamp within the loaded transaction log window.

Transactions & Alerts

Group activity by transaction and investigate INSERT, UPDATE, DELETE counts, transaction duration, and other available activity indicators.

Essential Filters

Filter transaction log activity by time range, table, login, transaction ID, operation type, and text search.

Multiple Log Sources

Analyze supported online database transaction logs, standalone .ldf files, full backup .bak files, and transaction log .trn backups.

Export & Reporting

Export filtered log entries and transactions to supported formats. Save recovery SQL and generate HTML reports for investigation and documentation.

How DBLense Log Reader Works

A straightforward workflow from log source selection to recovery script review.

Connect to Your Log Source

Connect to an online SQL Server database or select a supported offline transaction log or backup file.

Analyze Database Changes

Browse transaction log entries, filter operations, inspect transactions, and review old and new values.

Generate Recovery Scripts

Generate Undo/Redo T-SQL scripts for supported operations and review the scripts before executing them.

See DBLense Log Reader in Action

Watch how to analyze SQL Server transaction logs, investigate database changes, inspect modified records, and generate recovery scripts.

Common SQL Server DBA Challenges

Practical investigation and recovery workflows for day-to-day SQL Server support.

Investigate Deleted Records

Find supported DELETE operations and inspect affected records in transaction log analysis.

Investigate Unexpected Data Changes

Review UPDATE operations and inspect before-and-after column values.

Investigate Database Activity

Analyze transaction history and investigate activity associated with database users and transactions.

Review Schema Changes

Investigate CREATE, ALTER, DROP, and TRUNCATE operations.

Analyze Transaction Log Backups

Read supported offline transaction log and backup sources for forensic investigation.

Generate Recovery Scripts

Prepare Undo/Redo SQL scripts for review and controlled recovery workflows.

Simple, Per-User Pricing

Simple per-user annual licensing for SQL Server professionals and teams. Volume discounts are calculated automatically as your team grows.

Annual per-user license Volume pricing for teams Secure online checkout

Select your team size for automatic volume pricing:

Exact seat count:

1–5 users — $120/user/year

Annual license

Log Reader

$120 /user/year

≈ $10/user/mo  ·  $120 total

System Requirements

Operating System:Windows 10/11 or Windows Server 2016+
SQL Server:SQL Server 2012+ (fn_dblog / fn_dump_dblog)
Azure:Azure SQL Managed Instance
Permissions:VIEW SERVER STATE, sysadmin for fn_dump_dblog

Required permissions depend on the selected log source and SQL Server operation.

Recover Data & Investigate Changes in Your Transaction Logs

Investigate INSERT, UPDATE, and DELETE operations, review schema and TRUNCATE events, and generate recovery scripts for review before execution.

SQL Server Transaction Log Reader – Frequently Asked Questions

Answers to common SQL Server transaction log analysis, data investigation, and recovery questions.

How do I recover deleted data from SQL Server without a backup?

SQL Server transaction logs can contain information about database changes. DBLense Log Reader helps investigate supported DELETE operations and generate recovery scripts for review. Recovery depends on log availability, database configuration, and the operations performed.

Can I read a SQL Server .ldf transaction log file?

DBLense Log Reader supports analysis of online transaction logs and supported standalone .ldf files. Select the appropriate log source and analyze the available entries.

How do I undo a bad UPDATE or DELETE in SQL Server?

Use transaction log analysis to locate the relevant operation, inspect the affected values, and generate an Undo script where supported. Always review the generated SQL before executing it.

Is DBLense Log Reader the same as fn_dblog in SSMS?

Both work with SQL Server transaction log information. DBLense Log Reader provides a graphical interface to analyze log activity, inspect transactions, and generate recovery scripts without manually decoding raw log output.

How can I find who deleted a record in SQL Server?

Analyze available transaction log entries and use the available login, transaction, timestamp, and operation information to investigate the change.

Can I view old and new values from SQL Server transaction logs?

DBLense Log Reader provides a grid view for inspecting supported DML changes and their old and new column values.

Can I analyze SQL Server transaction log backup files?

DBLense Log Reader supports selected transaction log backup sources. Select the supported backup file and analyze the available log records.

Can I identify TRUNCATE TABLE operations?

DBLense Log Reader provides a separate Schema & Truncate view for investigating supported schema and truncate activity.

Does DBLense Log Reader automatically execute recovery scripts?

No. The application generates scripts for review. You control whether and when to execute them in your SQL Server environment.

Which SQL Server versions does DBLense Log Reader support?

Refer to the System Requirements section for supported SQL Server versions, operating systems, and required permissions.