QuickData SQL Log Explorer

4.8 Based on 60 Reviews

SQL Log Explorer

SQL Log Explorer plays a vital role in analysing, repairing the LDF file and password as well. Along with that, also allows to examine the NDF file.

  • Quickly analyze the transactions of SQL log file and helps in LDF file recovery.
  • Explore and read every transaction: DELETE, INSERT, UPDATE etc.
  • Preview each LDF Activity: Time, Transaction, Name, Query and Table Name.
  • Facilitates with the view and fetching records from Live Database.
  • Also repairs deleted records, In case the database is in Simple Recovery mode.
  • Presence of .mdf file is mandatory to perform the analysing process.
  • Also supports the forensic exploring of SQL Server log files.
  • This software application works online and in offline environment of SQL database.
  • Also supports advanced data types: datetimeoffset, Datetime2, hierarchyid, sql_variant, geography and geometry.
  • Supports SQL Server 2019 LDF files and below versions.
  • Supports Windows 10 and below versions with 32 and 64 bit operating system.

Distinct features of SQL Log Explorer

live database preview

View Records of Live Database

SQL Log Explorer tool permits you to fetch all the records of database online using correct credentials. So that, You can preview the entire records such as UPDATE, DELETE, INSERT etc. With this, you can connect to database online to access the transaction logs.

analyze all logs

Every SQL Transaction is Analyzed

Using SQL Log Explorer, entire SQL Log activities can be read, open and preview. Preview activity includes: Transaction time, transaction name, query, table name etc. Since, SQL Server stores all its transaction and activity logs in .ldf file. So, It is easy to find out the expected reason of SQL Server corruption.

view all items

View all SQL log Transactions

This tool loads and scans all the tables of SQL database and provide a preview of all transactional activities stored in LDF file. This LDF Viewer facilitates with the view of transaction logs like: Transaction name, time and query. You can also view the records with Login Authentication for Delete, Insert, Update etc with their other details like id, class, status and name.

multiple options

Multiple options to Extract Log file of SQL

This tool helps you by exporting the queries of SQL log files as SQL files in three ways:
-- Export as SQL server compatible SQL Scripts.
-- Export as SQL server database.
-- Export as CSV file.

extract database

Option to Export as SQL Server Database

On choosing option “Export as SQL Server Database” i.e. exporting the all LDF file queries to SQL Server Database then you have to provide all credentials of the database like database name, server name, username and password. Note: In order to avoid the overwriting of present database, export data to any other location in SQL Server.

transfer data

Transfer recovered data to SQL Scripts compatible to SQL Server

If you are in a situation to transfer repaired data to different SQL Server database then you should export the queries of SQL LDF file to the SQL Server compatible SQL scripts. From this SQL script, You can move the data in any SQL Server according to your need.

detect data

Auto detection of MDF file with the LDF file

This software provides an additional feature that it will automatically find out the associated .mdf file. However, MDF and LDF file should be located at the same location. Otherwise, you have to browse the location of MDF file separately. In order to repair corrupt SQL Server database, you need to provide the Login details for last backup of SQL data.

view multiple files

Analyze Data of Multiple NDF files

SQL LDF Viewer tool permits you to analyze multiple .ndf files. With the help of this feature you can analyze data of different secondary database files to view entire records within the NDF file.

sort file

Sort elements of Log File

An option is available of automatic sorting to re-arrange the order of list items.This tool allows you to sort the components according to their properties like as transaction time, transaction, transaction name, table name and query.

selective data

Selected tables Exported

During the exporting process of .ldf files, you can export the selective tables as per your requirement. You can also export particular folder or data from any specific table as CSV, SQL data base or SQL compatible script.

Introduction to SQL Server Log(LDF) files

SQL Server log files with an extension of .ldf may be defined as a transaction log containing log records generated during the logging process involved in SQL Server database.

Benefit of log files:

A transaction is a single element for entire process. If a transaction ends in successful manner then all the modifications done to the database gets committed and permanently become a part of the database. The most effective benefit of log files is that if the transaction experiences any error and should be cancelled or rolled back then the modifications in the data will get erased.

Download Trial

Demo Limitation:

Free SQL Log Explorer will preview the entire data, but does not permits you to export the data.

System Specifications:

  • Disk Space : Around 100 MB free space for installation
  • MDF file is essential to analyze the database
  • The tool works for online as well as Offline SQL database


Supported Platforms:

  • SQL Server: SQL Server 2019/2017/2016/2014/2012/2008R2/2008 or below
Product Guide

Step 1: Click Open button to upload desired LDF / MDF file from the system.

add file

Step 2: You will get two options for adding transaction log file
-- Online DB Option
-- Offline DB Option
Choose Online DB Option. Input the Authentication detail, Server Name and Database. Then click OK

select db option

Step 3: After the completion of scanning process. Click OK on scanning window.

scanning data

Step 4: You can easily preview the details of events by clicking on each transaction from the panel. The logs can be sorted according to their Transaction, Table Name, Time and so on.

preview details

Step 5: After analyzing the log file, click on Export.

Export data

Step 6: You can enable the type of transaction that you want to export – Insert, Update, Delete for export task. You are free to select all of the options or go with the selective one

save dml transaction

Step 7: Apply Date Filter option to export a selected timeline transaction

apply date filters

Step 8: There are three options to export the log file – SQL Server Database, SQL Server Compatible SQL Scripts, CSV.

select export type

If you opt the SQL Server Database, then you need to provide the details of SQL Server running in your system.

fill database credentials

Step 9: Finally, hit the Export button to initiate the process.

SQL Log Explorer

Click Yes, If you want to save the .csv file.

save .csv

Step 1: After selecting the Offline mode, you need to enter the LDF & MDFfile.

select offline mode

Step 2: After receiving a notification of completion of scanning process, You can save that in .str format.

save scanned file

Step 3: Preview of all transaction logs will appear with details – Transaction, Login Name, Time, Table Name, Transaction Name, Query. You can choose the tables that you want to export. Afterward, click on Export button.

export transactional logs

Step 4: You can choose Export Filters option to restore desired transaction. Date filters can also be applied.

export options

Step 5: Select the location where you want to save log file - SQL Server Database, SQL Server Compatible SQL Scripts, CSV. Then click on Export.

export log data

Step 6: Export process is also visible. Respond to the notification if you want to save the Export report in .csv format

save as CSV

Watch working of SQL Log Explorer Through A Video

Get Clear All Doubts & Queries Related to Product!

SQL Server is required only in case of exporting into SQL Server Database.

No, It is not possible to view log file without MDF file.

Client Reviews for SQL LDF Viewer Software