SQL log analyzer process lets you view SQL database transaction logs like insert, update & delete as well as SQL queries that were executed on your database. SQL log reader tool has an interactive GUI which makes the transaction log reading process easy for the users.
Some Handy Features of SQL Transaction Log Analyzer are described below:
Analyze SQL Server Log File
SQL log analyzer allow you to open and read SQL Server transaction log file without installing SQL Server in your machine. SQL log reader can show the transactions like Insert, Update, Delete with Transaction, Login Name, Time, Query etc.
Sort Log File Transaction Detail
Once the log file with its associated .mdf file is successfully scanned by SQL Log file viewer, then the software can preview the log file information and allow you to sort the transaction details in ascending or descending order according to your choice.
Support Different SQL Server/ Windows versions
SQL log file reader is compatible with different SQL Server versions like 2005, 2008, 2012, 2014, 2016, 2017. Hence it can easily support the transaction log files of mentioned versions of SQL Server. As well as Software can also run on windows Xp, 7, 8, 8.1 & 10.
Support Advanced Data Type
SQL log analyzer now also supports Advanced data types like Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography for the advanced forensics of SQL transaction log file
Perform SQL Log File Recovery
SQL transaction log reader tool not only analyzes SQL Server log file, it also performs SQL Log file recovery through database transaction logs. Once the software completely scans the log file, it recovers the transactional information of your database by exporting the database elements.
Recover Accidentally Deleted Data
SQL transaction log analyzer not only shows the deleted records of a table, it also provide you the option to recover accidentally deleted data from a table in SQL Server database and get back your mistakenly deleted records from transaction log file.
Export Selective Items by Check or Unchecked
After completely analysing SQL transaction logs, SQL log file viewer allow you to select desired database items and export by check or unchecked them. This will help you in recovering a particular record from log file database.
Save Scanned Items Into .str
Once the log file successfully scanned by SQL Server log analyzer tool, software allow you to save the scanned detail in .str file format for later use. So the next time you don't need to re-scan the log file data.
Multiple Options to Export Data
SQL log file reader lets you save transaction log file detail in three different ways:
Launch SQL Log Viewer
Click on Open to load sql .ldf file
Browse .ldf File by manual select option.
Select .ldf file by clicking on Open button.
Also Select associated .mdf and click on Scan File.
Preview the records by expanding database tables
Sort database elements by Transactions, Login Name, Time, Table Name, Transaction Name & Query.
Select desired database tables to Export its data.
Click on Export button to export selected tables data
Export data with three different options: SQL Server database, .sql file, csv file
Filter Transactions according to your need
Similarly Filter transaction according to Date.
Select the destination to be exported on
Exported log file data successfully.
We are professional provider of E-discovery tools like SQL Log analyzer that provides foolproof satisfaction in analyzing SQL log files transactions for SQL Server 2005 & 2008. We are expert provider of SQL log file viewer and Server related services for highly specialized administrators and other individuals who deal with SQL Server database.
Frequently Asked Questions
I was searching for the way to view my database transactions and I have found some undocumented functions which were helpful in viewing transaction logs from SQL Server log file, but the process is too long and time consuming, then I tried this SQL log reader tool to view my log file transactions.
I accidentally deleted some of my database tables records with wrong WHERE clause. After checking the table I found that I have lost a huge amount of data, and unfortunately command was not performed within a transaction and no recent backup available for its recovery, after searching for the solution I got this SQL log analyzer tool helpful in recovery of that records using ldf file.
I was looking forward for a reliable tool that can help exporting log transaction files to CSV files with all incorporated log details such as Insert, Delete, Update, etc. SQL Log Analyzer fulfilled the requirement and also provided the option to export log files as SQL Server Database and SQL compatible scripts with efficient performance.
Note: Software will get delivered on your registered email id, within 15 minutes after placing the order.