Stellar Log Analyzer for MS SQL

SQL Transaction Log Analyzer Tool

Efficient tool designed for database administrators to audit SQL database transaction log file (.ldf). It saves the user time to perform an in-depth forensic analysis of transaction log files. The tool helps analyze the log file data to track all the transactions written to the SQL Server database. The user can preview all the transaction details, including Transaction Type, Transaction Time, User, Transaction Name, Table Name, and Query. Also, it allows to save the SQL Server transaction log and data in readable form.

  • Analyze and view transactions of SQL database LDF file
  • Detailed preview of Insert, Update, Delete, Create, & Drop transactions
  • Analyze deleted transactions and saves table data
  • Support multiple file formats, including MDF, CSV, HTML, & XLS
*Free download allow to see preview of complete details related to the transactions.

Stellar Log Analyzer for MS SQL

When to Use Stellar Log Analyzer for MS SQL?

Need to View and Read Transaction Log?

The MS SQL Log Analyzer tool helps the user to view and read MS SQL transaction log without manual efforts. It scans the LDF and MDF files and displays a preview of the transactions performed on a database in a simplified manner. The preview comprises Transaction Type (Insert, Delete, Update, Create and Drop), and Transaction Time. Users can also preview complete query details of each transaction.

Need to Perform Forensic Analysis of SQL Database?

The SQL transaction log analyzer tool helps you get detailed information about the transactions written to the database. You can track manipulated data (Insert, Update, and Delete) in the database or any changes made to the database. With this tool, you can also analyze deleted/dropped table data without performing the full database restore process.

Want to Save Log Transactions in a Readable Format?

The SQL log file is saved in an unreadable format. With the help of SQL Log Analyzer tool, you can easily read all the transactions and view the data in the Preview pane. After previewing, you can save the transactions along with the data in a readable and sorted manner.

Features

Performs Forensic Analysis of SQL Transaction Log icon

Performs Forensic Analysis of SQL Transaction Log

The MS SQL log analyzer tool scans a SQL database log (LDF) file and its associated MDF file. It displays a preview of data manipulation operations such as INSERT, UPDATE and DELETE and database DDL operations, such as CREATE and DROP. Also, it previews the Transaction Time, Transaction Type, and Query details. This feature helps perform forensic analysis of the records of all transactions written to the database.

Enhanced Preview of Log File Transactions icon

Enhanced Preview of Log File Transactions

After scanning, the software displays an enhanced preview of database transactions and their data. You can view Insert, Update, Delete, Create, and Drop operations performed on SQL database tables in the Preview window. Also, you can view a transaction start and end time, transaction name, and detailed query view.

Multiple File Saving Options icon

Multiple File Saving Options

After previewing the SQL transaction log file (.ldf) data, the tool saves the log file contents in a readable format. Users can save tables’ data of a log file in MDF, CSV, HTML, and XLS, and log transactions in CSV, HTML, and XLS file formats. The SQL log file analyzer tool also provides the option to save the log file data to a new or an existing database.

Create New Database with Recovered Items  icon

Create New Database with Recovered Items

The SQL Log File Analyzer tool allows saving deleted or dropped transactions to a new database. Thus, it enables users to auto-create a database with all the recovered items in a SQL database. The tool also provides the option to save the recovered data to an existing database connected to the server.

More Awesome Features

Option to Select LDF & MDF Files icon

Option to Select LDF & MDF Files

If MDF and LDF files are saved in the same location, the tool automatically detects the MDF file associated with the LDF file. However, if the files are stored at different locations, users can browse the location of the MDF file by using the Select MDF option. The SQL Server transaction log viewer tool also provides the 'Find' option to locate LDF files saved in your computer's drives, folders, or subfolders.

Data View of Tables Transactions icon

Data View of Tables Transactions

The software shows Insert, Update, and Delete transactions performed for a table. Also, users can see original and modified data of an Update transaction in the Data View. The Data View section is available at the bottom of the software interface.

Option to Search for Specific Items icon

Option to Search for Specific Items

Users can search for a specific item by entering its name in the search bar when viewing log tables data and log transactions in the Preview window. The tool also offers Match Case and Match Whole Word options to narrow down the search and quickly find any particular items in large SQL Server LDF files.

Saves Log File Data for Specified Period  icon

Saves Log File Data for Specified Period

The software provides an option to apply a date range filter to view and save log tables data and log transactions for a specified interval. This feature saves time and effort in viewing transactions for a specific point in time. It also generates a log report of the complete LDF and MDF file saving process, including details like start and end time of the saving process, selected database version, etc.

Product Tour for Stellar Log Analyzer for MS SQL

Technical Specifications

About Product


Stellar Log Analyzer for MS SQL

Version

1.0.0.0

Release Date

May, 2021

License

Multiple Users

Version Support

MS SQL server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, and earlier versions

Edition

Technician

EULA

EULA

Language Supported

English

System Requirement


Stellar Log Analyzer for MS SQL

Processor

Intel-compatible (x86, x64)

Operating System

Windows 10, 8.1, 8, 7 & Windows Server 2012, 2008

Memory

4 GB minimum (8 GB recommended)

Hard Disk

250 MB of free space

Download Guides


TRY IT OUT FOR FREE

Start Using Stellar Log Analyzer for MS SQL Today With Our Free Trial.

*Free download allow to see preview of complete details related to the transactions.

Start Using Stellar Photo Recovery Today With Our Free Trial

FAQ

A.
The SQL Log Analyzer free demo version allows you to view and read transaction log file data. The steps are as follows:
  • Download the demo version of Stellar Log Analyzer for MS SQL software.
  • Install and run the software.
  • Select the LDF file you want to analyze by using the 'Select LDF File' button or use the'Find LDF' button to search for the file.
  • Click 'Analyze' to initiate the analysis process.
  • After completion of the analysis process, a preview of log tables data and log transactions is displayed in a tree-like structure in the left pane. You can view the transaction details in the right pane, including Transaction Type, Transaction Name, Query details, etc.

To save the data, you need to purchase and activate the licensed version of the software.

A.
You can use the SQL Log Viewer tool from Stellar® to view the transaction log file (.ldf) contents without SQL Server installation.
A.
If the LDF and MDF files are saved in the same location, the software automatically selects an MDF file associated with an LDF file. However, if the files are saved in different locations, you can use the 'Select LDF' option to choose a log file and select its associated MDF file using the 'Select MDF' option.
A.
Yes, you can use the Date Range filter to save specific transaction logs.