Size: 8.21 MB Version: 7.0

Screenshots

Video

SQL Log Analyzer

SQL Transaction Log Analysis Tool is an innovative utility to view, read and analyze transaction Log files in SQL Server. The SQL Log Analyzer supports to view LDF file and recover SQL transaction Log file data on SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019 editions.

(Average Rating 4.7 Based on 105 Reviews)

Analyze SQL transaction Log file & execute SQL .ldf file recovery
Recover and export deleted data from transaction Log of SQL Server
SQL LDF File Viewer supports to open, read and analyze .ldf files in Microsoft SQL server 2019, 2017, 2016, 2014, 2012, 2008 and 2005 editions in Windows Operating System.
View Log files & provides option for quick scanning of SQl LDF files
Easily Preview Insert / Update / Delete operations
Open records in Live database & preview several LDF file activity
SQL Log Analyzer preview .ldf actions like Transaction, Time, Name, Table Name, & Query etc. And also it allows to open, read and analyze different SQL transactions like INSERT, DELETE, UPDATE etc.
Export SQL Log file as SQL Script, as SQL Database or as CSV file
Supports Unicode data table after the export and advanced data types
SQL Server Log Analysis tool supports advanced data types namely Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography data types etc.
SQL Log Recovery Tool can operate well on Online and Offline database

Download Now
Safe & Secure

Purchase Now
30 Days Money Back*

Detailed Features

Features of SQL Log Analyzer Software

Database Records

Preview Live Database Records

SQL Transaction Log Reader tool permits the user to connect to online SQL Server Database (live) using the credentials to fetch database and records automatically. It also provides options to select SQL Server Database version, if database file version is not detected automatically. This allows the user to view, read and analyze SQL records and various transactions like INSERT, UPDATE, DELETE etc. within the database. This inbuilt feature in LDF Viewer allows the user to connect to Live Database for accessing transaction log files.

Log Transaction

Analyze SQL Log Transaction Activity

SQL Log Viewer allows to open, read, preview and analyze SQL server transaction Log activity in an SQL Server database. Since SQL Server saves log activity and transaction details in the .ldf file; analyzing and detecting of SQL Server corruption is easy. SQL Server Transaction Log Analyzer preview includes; Transaction name, Transaction time, Table name, Query etc. And also SQL LDF Reader scans and loads tables present in SQL database easily.

Quick Recovery

Quick Data Recovery Through SQL LDF File

In order to avoid the entire scanning of corrupted SQL Server database file for recovery, SQL LDF Recovery utility would be beneficial. In such cases, the user needs to provide the healthy .ldf file of SQL Log file with the associated MDF file (Primary SQL database file) for a quick recovery. After that, this SQL Log Analyzer tool will scan and export the complete data to SQL Server and its compatible formats.

CSV file

3 Options to Export SQL Log File

The MS SQL Transaction Log Analyzer tool provides 3 options to export SQL transaction log files queries.
1.Export it as SQL Server database.
2.Export as SQL Server compatible SQL scripts.(for recovered data)
3.Export it as a CSV file.
Note: To export SQL LDF file directly to SQL Server database, users need to provide valid credentials like Server Name, Database Name, Username and its password.

MDF File

Add the LDF and MDF File

With the help of SQL LDF Viewer software, when a user adds single SQL LDF file at a time, the application automatically detects MDF file associated with it if both the files are in the same location. Otherwise, the user needs to browse separately for the MDF file. In case if the user wants to recover corrupted SQL Server database then, need to provide all the Log details of the last SQL data backup.

Sort the Elements

Options to Sort the Elements of a Log File

The auto-sorting option is available in SQL Log Analyzer utility to re-arrange the order of the list of items in Log file data. The users can sort the elements in the transaction file according to different properties like transaction, login name, transaction time, table name, transaction name, and query. The product also displays the details of any transaction of a particular table in the SQL database.

Latest Version

Recover the Database from Latest Version

The analyzed SQL file can be used to recover the corresponding corrupt database on the server. The SQL Transaction Log Viewer software supports versions of MS SQL Server like SQL Server 2019, 2017, 2016, 2014, 2012, 2008, and 2005 editions. Therefore, one can recover deleted records from transaction log files if the database is in Simple Recovery Mode. The database can be easily recovered and exported.

Log File

Log File Forensics without SQL Server

SQL Server Log file analyzer supports forensic analysis of Transaction Log files for the examination of various SQL Server activities. The utility is a standalone tool to view SQL transaction log and it doesn't need Microsoft SQL Server installed on the machine for the analysis. It works on all versions of Windows OS, like Windows 10, Windows 8.1, Windows 8, Windows 7 and Windows XP (for 32 & 64 bit).

Selective Data

Export Selective Data Using SQL Log Analyzer

While exporting SQL Transaction Log LDF file queries, one can check or uncheck the tables to save only the selected data that are necessary for the user. If the user needs to recover SQL LDF file data from any specific table in the database then select and export those particular folders as SQL database, CSV or as SQL Server compatible script accordingly.

Overcome Errors

Save and Load the Scanned Log File

Once the scanning of SQL Log file is done, this SQL Log .str file can be saved for the future use. That is, this scanned copy of the transaction Log file can be saved as an .str file in order to avoid the rescanning of that file every time when there is a need for it. One can just load this saved STR file to work on the scanned SQL Log file. This option is available for Offline database only.

Step 1: Download, Install and run the SQL Log Analyzer Tool to view and analyze SQL Server transaction Log data in the system.

how to open sql server database transaction log file (.ldf)

Step 2: Click on the Open tab to add the .ldf or .mdf file to the utility. Choose Online or Offline database accordingly to the need.

view sql log file transactions

Step 3: Consider Offline database, click on the LDF file path Browse button to load SQL transaction LDF file.

Step 4: Select the LDF file and click the Open button.

add mdf file

Step 5: Now browse and add the corresponding MDF file and click on OK button. And also Fetch User to retrieve User of server.

view sql server transactions

Step 6: Click on the Ok when scanning completes and view all the complete scanning details like No. of inserts, No. of Deletes etc. And click on the OK button.

save transaction in sql server

Step 7: Now SQL Log Analyzer can save the scanned file in .str file format at the desired location.

view contents of ldf file

Step 8: Now preview the selected Log (.ldf) file data for each table in the database.

export log file

Step 9: Select the Table by clicking on the checkboxes provided to export SQL transactions Log files and press on the Export button.

store the export report file locally

Step 10: Export data according to transaction: INSERT, UPDATE, DELETE.

export SQL database log files

Step 11: Export Log transaction records of selected date using Date Filters option.

save sql data using SQL log Analyzer

Step 12: Choose the Export option to save the SQL Records as SQL Server database, SQL Server compatible scripts or CSV file.

SQL Log Transaction Analyzer

Step 13: Now Fill the database credentials.

SQL transaction information

Step 14: The user can create the new database or export to existing database.

preview sql data detail

Step 15: A prompt up window will open that will ask - Do you want to Export the Details to a .csv file? Click Yes if you want.

view sql server transactions

Step 16: Preview the .sql file with help of SQL Server Database in the system.

Video

SQL Server Transaction Log Viewer

“I have mistakenly deleted few records in my database of SQL Server 2012 version. Will the tool be able to restore these deleted data from SQL transaction Log file?”

“One of my friends, send me few SQL LDF files. When I try to view those files, I understood the folder doesn’t contain MDF files in it. Now, I want to know that, whether I can view SQL Log files without MDF files using this utility?”

“Some of the database records in my SQL Server 2008 are deleted. I just need to know, can this MS SQL Transaction Log Reader can recover the file and export those SQL files?”

“I want to explore NDF files in my MS SQL database server 2016. Is it possible to view SQL Transaction Logs of multiple NDF files using this SQL Log Viewer tool?”

“My Microsoft SQL Server database is having many advanced data types in it. Now I need to transfer SQL Log files. I tried many tools but failed. Will this product support new data types?”

“I am using Microsoft SQL Server 2016 on my system. Now I need to view and analyze SQL Server database files using this software. I want to know, whether this application can work on SQL 2016 version also?”

Reviews

Client Testimonials for SQL Log Analyzer

Sahil Makheeja

"Due to some carelessness from the SQL Server administrators, the database ended up with the corrupted SQL database. But after working with SQL Transaction Log Viewer to recover all my data from the corrupted SQL database, I feel so thankful to the entire team worked behind this application. Kudos!!"

Sahil Makheeja, Mumbai

Martina Christopher

"SQL Log viewer is one of the best tools to recover SQL transactions log files. I had been trying to restore my MDF file with the help of Log file but it failed. That's when my friend suggested me to use SQL Log Analyzer software. It worked amazing for me. I rate this tool 5 out of 5. Thanks!!"

Martina Christopher, Russia

Arun Kumar

"I was searching for an option to view deleted transactions in my Microsoft SQL Server. Finally I came across SysTools SQL Server Transaction Log Analysis tool. I was confused whether this utility could view and analyze database records that have been deleted. But the SQL Log Recovery worked well for me. Thanks to the team."

Arun Kumar, Kerala