SQL Log Explorer

Screens

Video

Guide

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 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 View and Fetching Records from Live Database
  • Also Repairs Deleted Records, In Case Database is in Simple Recovery Mode
  • Presence of .mdf File is Mandatory to Perform SQL Log Analysing Process
  • Also Supports Forensic Exploring of SQL Server Log Files in Windows OS
  • This Software Application Works Online and in Offline Environment of SQL Database
  • Supports Advanced Data Types: datetimeoffset, Datetime2, hierarchyid, sql_variant, geography, geometry
  • Supports SQL Server 2019, 2017, 2016, 2014, 2012, 2008 and SQL Server 2005 LDF
  • Supports Windows 10, 8, 7 (32 bit or 64 bit) and Windows Server 2016, 2012 R2, 2008

Download Now
Safe & Secure

Purchase Now
30 Days Money Back*

SQL Log Explorer – Overview

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.

Distinct features of SQL Log Explorer

Highlighted Features of SQL Log Analyzer Tool

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 SQL Scripts Data

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 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.

SQL Log Explorer System Requirement

Software Download

Size: 9.46 MB

Version: 9.0

MD5: be072ccdb8bae60b0bf7f6ce968270c4

Trial Limitations

Limitations
Demo of SQL Log Analyzer Tool provides 7 Days Free Trial to preview all the tables (50 records per table). Free Version does not provide option to export data.

System Specifications

Hard Disk Space
100 MB of free hard disk space required

RAM
4 GB of RAM

Processor
Intel® Core™ 2 Duo CPU E4600 @ 2.40GHz 2.39GHz

Supported Editions

Windows 10, 8, 7 (32 bit or 64 bit) and Windows Server 2016, 2012 R2, 2008.
SQL Server 2019, 2017, 2016, 2014, 2012, 2008 / R2, 2008, 2005 & 2000

Pre-Requisites

  • Microsoft .NET framework 4.6.1 or above should be installed.
  • If you are using Windows 10/8.1/8/7 or Vista, then please launch the tool as "Run as Administrator"
  • MDF File is required to analyze the database in offline mode
  • Exporting in Live SQL Server: SQL Server should be installed in the user system

FAQs

Q. Is your Antivirus blocking the software export process?

A. Please disable Anti-virus temporarily / Allow access (Whitelist) from Antivirus settings for proper working of the software.

Q. Unable to Create Output in destination?

A. Please avoid NAS, SAN, Network or Shared Drive. Source file should be on the migration machine to perform successful conversion.

Electronic Delivery

The delivery of the product is automated, You will receive an email containing both the link to download the product and the activation key within few minutes after payment confirmation.

Features Comparison

Get an Overview of SQL Log Analyzer Features – Free and Full Version

Features FREE Version FULL Version
Add SQL LDF File
Access Records from Live Database
SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2 Database & 2005
Windows 10, 8, 7 (32 bit or 64 bit) and Windows Server 2016, 2012 R2, 2008
Preview & Sort Log Fields Unlimited Tables Unlimited Tables
Preview Row of Selected Transaction 50 Records / Table Unlimited Tables
Multiple Filters Option Available in Full Version
Export Log File into SQL Server Database Available in Full Version
Export into SQL Server Compatible SQL Scripts or CSV Available in Full Version
Cost FREE $99

Frequently Asked Questions

Listed Commonly Asked Questions and Answers

Yes, the tool supports Windows 10 OS and all compatible versions.
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.

What Customers Are Saying

Verified Purchase Reviews – SQL LDF Viewer Tool

4.8
1189 Ratings
5 Star
80%
4 Star
15%
3 Star
3%
2 Star
1%
1 Star
1%