SQL Server Transaction Log Viewer
SQL Log Analyzer Tool to View LDF Transaction Logs
SQL Log Analyzer software opens SQL Server LDF files and lists every transaction with its login, time, table and query. Filter records by type and date, then use the tool to export them to a database, scripts or CSV.
- Shows login name, time and query
- Works in online and offline mode
- Filters insert, update and delete records
- Analyzes logs without SQL Server
- Free DemoPreview your own log
- 30 Day RefundDemo test comes first
- Card or PayPalHosted store checkout
- Key by EmailSent after payment
- 24x7 SupportChat and email
1What can I find out?
Which Questions Does SQL Log Analyzer Answer?
Find your question below. SQL Log Analyzer turns a raw LDF file into a sortable list of transactions.
- Who Changed This Table?Login names show beside every change.
- Who Deleted These Records?Delete transactions list the table, the time and the query.
- When Did the Change Happen?Every transaction carries its date and time.
- Which Query Changed the Data?Query text shows beside every transaction.
- Audit or Forensic Review DueInvestigators get login, time and table details without touching the live server.
- Lost Records Need a RebuildExport chosen transactions to SQL Server, scripts or CSV and rebuild what changed.
MDF File Offline
Offline mode needs the MDF file. LDF files alone do not open.
Log Files Only
Dedicated log files open. Backups of LDF files do not.
Online Mode
Connect to a live SQL Server with a server name and credentials.
Microsoft states that the transaction log records all transactions and the changes they make. Truncation then frees log space for reuse. Old records go with it.
Truncation happens after a checkpoint under the simple recovery model and after a log backup under the full model. Learn the details in the Microsoft guide to the SQL Server transaction log.
2What changes?
What Changes After You Open the Log?
Before
- Nobody knows who changed the table
- Deleted rows leave no visible trace
- The LDF file stays unreadable
After
- Login, time, table and query show per transaction
- Filters narrow records by type and date
- Records leave as a database, scripts or CSV
3What can it do?
Which Features Come With SQL Log Analyzer?
SQL Log Analyzer software keeps online mode, offline mode, filters and exports in one window.
Full Transaction Details
Every row shows the transaction, login name, time, table name, transaction name and query.
Insert, Update, Delete
Click a transaction and its records appear in the preview pane with column names.
Online and Offline Modes
Connect to a live server or load LDF and MDF files from your drive.
MDF Auto Locate
Add an LDF file and its MDF file loads when both sit in one folder. Otherwise browse to it.
Sort and Filter
Sort by transaction, login, time, table or query. Filters limit an export to a record type or a date range.
Three Export Options
Export to a SQL Server database, SQL Server compatible scripts or CSV files.
Selective Table Export
Tick the tables you need and leave the rest behind.
Saved Scans in STR
Save a scanned log as an STR file and load it later without a rescan.
Advanced Data Types
Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry, geography, JSON and vector columns are covered.
4Is it easy?
How to Try SQL Log Analyzer Free in 4 Steps
View your own transactions inside the demo tool. Buy the license when the list answers your question.
- 1Download
Install the Demo
Download the 10.28 MB Windows installer. Open it with Run as Administrator.
- 2Open
Choose Online or Offline
Select Open, then use the Online DB or Offline DB tab to add your database and log.
- 3Preview
Browse the Transactions
Sort the list and click a transaction to see its records. Demo mode shows 50 records per table.
- 4Export
Activate and Export
Enter your license key, apply filters and export in the format you need.
Demo mode lasts 7 days and blocks every export. Screens for all four steps sit in the SQL Log Analyzer guide.
5What will I see?
Which Screens Appear in SQL Log Analyzer?
Follow the tool from the connect window to the export window.
Choose Online or Offline
Online mode takes a server name and authentication mode. Offline mode loads files from a drive.
Filter and Export
Tick insert, update or delete, add a date range and choose a database, scripts or CSV as the target.
6Demo or full?
SQL Log Analyzer Demo vs Full Version
See what the full software adds to the free demo.
| Feature | Free Demo | Full Version |
|---|---|---|
| Add LDF file | Yes | Yes |
| SQL Server 2025 to 2000 support | Yes | Yes |
| Access records from a live database | Yes | Yes |
| Preview and sort log fields | Yes | Yes |
| Records previewed per table | 50 | Unlimited |
| Multiple filters | No | Yes |
| Database export | No | Yes |
| Export to SQL scripts or CSV | No | Yes |
| Price | Free | From $99 |
7Can my PC use it?
System Requirements for SQL Log Analyzer
| Product Version | 9.3 |
|---|---|
| Download Size | 10.28 MB |
| Product Type | Windows desktop software for transaction log analysis |
| Supported Files | Dedicated LDF log files with their MDF file. LDF backup files do not open. |
| SQL Server Versions | SQL Server 2000 to 2025, 2008 R2 included |
| Windows | Windows 11 (64 bit), plus 10, 8.1, 8 and 7 in 32 or 64 bit. Windows Server 2025 down to 2008 also works. |
| Mac | Not available. SQL Log Analyzer works on Windows only. |
| Processor | Intel Core 2 Duo E4600, 2.40 GHz |
| RAM and Disk Space | 4 GB RAM with 100 MB free on disk |
| Framework | .NET Framework 4.5 or newer |
| SQL Server Needed | Not for analysis. Exporting to a live database needs SQL Server on the computer. |
| MDF File | Required in offline mode to learn the schema |
| Launch Method | Right click the shortcut and choose Run as Administrator. |
8What will it cost?
What Does SQL Log Analyzer Cost?
Choose a software license length for every machine you use. Checkout offers 1 to 11 months or 1 year, with prices in US dollars.
1 Month
$99
- Price for one machine
- Filters and exports unlocked
- License key by email
Want log analysis with more tools? SQL Server Recovery Manager adds MDF, NDF and BAK repair, SA password reset and script decryption at $299 per machine per month. Larger orders above 500 machines start with an email to support@systoolsgroup.com. More offers sit on the RecoveryTools offers page.
9Is it safe?
Can You Trust SQL Log Analyzer With Your Logs?
Test on Your Own Log
Open your own LDF file in the free demo and judge the transaction list before you pay.
Serving Users Since 2007
Customers in more than 100 countries use software from the company behind RecoveryTools, which dates back to 2007. See the about page.
ISO Certificates
ISO 9001:2015 covers quality and ISO/IEC 27001:2013 covers information security. See the certificates on the awards page.
Terms Before Checkout
Public pages explain refunds, privacy and usage. Open the refund policy, privacy policy and terms of use before you buy.
10Need a hand?
Which Support Options Cover SQL Log Analyzer?
Presales and after sales tool questions reach the same engineers. Phone numbers sit on the RecoveryTools support center.
Live Chat
A live chat reaches a support engineer for connection and export questions.
Email Support
Email support@systoolsgroup.com with your SQL Server version, the file names and the message you see.
Remote Help
An engineer joins your computer and opens the log with you.
Private Data
Large log files travel by secure upload. Ask for a Non Disclosure Agreement first when the data is private.
11Still have a question?
SQL Log Analyzer Questions and Answers
What is SQL Log Analyzer used for?
SQL Log Analyzer opens SQL Server LDF files and lists every transaction with its login name, time, table and query. Export the records as a new database, SQL scripts or CSV files.
Can Log Analyzer show who changed a table?
Yes. Login names show beside every insert, update and delete transaction.
Does Log Analyzer need SQL Server installed?
Not for analysis. Exporting to a database needs a SQL Server environment.
Can Log Analyzer open an LDF file without its MDF file?
No. Offline mode needs the matching MDF file to learn the database schema. Online mode connects to a live server instead.
How do online and offline mode differ?
Online mode connects to a live SQL Server with a server name and credentials. Offline mode loads the LDF and MDF files from your drive.
Can Log Analyzer open LDF backup files?
No. Dedicated log files open. Backups of LDF files do not.
Which operations does Log Analyzer list?
Insert, update and delete transactions appear with their table, date, time and query. Filters narrow the list before you export.
Why are old transactions missing from my log?
SQL Server truncates the log to reuse space. Microsoft states that truncation happens after a checkpoint under the simple recovery model and after a log backup under the full model. Truncated records no longer sit in the file.
What can the free demo of SQL Log Analyzer do?
Demo mode previews all tables with 50 records per table for 7 days. Filters and every export need the full version.
Which SQL Server versions work with SQL Log Analyzer?
Log files from SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000 work. Installation works on Windows 11, 10, 8.1, 8 and 7 or Windows Server 2025 down to 2008.
How much does SQL Log Analyzer cost?
One machine costs $99 per month. Six months cost $594 and one year costs $1,188 per machine. Orders cover 1 to 500 machines.
Can I get a refund on SQL Log Analyzer?
Yes, after you complete the free demo test. Mail sales@recovery-tools.org during the 30 days after buying and attach a signed Letter of Destruction. Conditions are listed in the RecoveryTools refund policy.
12Where next?
More SQL Server Tools and Log Guides
Test SQL Log Analyzer on Your Own LDF File
Download the free demo, browse your transactions with the tool and buy a software license when the answers look right.