SysTools SQL Log Analyzer

An E-Discovery tool to Analyze SQL Log File (.ldf) Transactions & Quickly Recover Corrupt SQL Data

List of Key Features in SysTools SQL LOG Analyzer

analyze sql files

Analyze all SQL Log Transaction

SQL Log Analyzer allows you to open and preview the complete log activity in an SQL Server database. Activity preview includes; Transaction name, transaction time, table name, query etc. As SQL Server saves all its log activity and transaction details in .ldf file, it is easier to analyze it to detect the possible reason of SQL Server corruption.

quick sql data recovery

Quick SQL Data Recovery

To avoid complete scanning of corrupt SQL Server database for recovery SQL Log Analyzer will be a great help. You only need to provide the last backup of your SQL log file with associated MDF file (Primary SQL database file). Software will scan & export the complete data in SQL Server compatible format; after thorough analysis. read more

add sql files

Add LDF & MDF File

Using the software you can add single SQL log file (.ldf file) at a time and it will auto detect associated MDF file; if both are present at same location. Otherwise; you will need to separately browse the MDF file location. In case you want to recover the corrupt SQL Server, you have to provide the LOG details for last backup of your SQL data.

preview

Preview All SQL Log Transactions

SQL Log Analyzer scans and loads all the tables present in SQL database and generates a preview for all transaction activity saved in LDF file. It shows the transactions with fields like: Transaction, transaction time, Table name and query. You can view the operations like: Insert, Delete, Update etc. with their details such as; class, id, name and status.

export sql log file

3 Options to Export SQL Log File

SQL Log Analyzer lets you export the SQL log file queries as SQL files in three different ways:

  • Export as SQL Server database
  • Export as SQL Server compatible SQL scripts
  • Export as CSV file

These exported queries as SQL files can be further used to get the corrupt SQL database in its working stage.

sql server database

Export as SQL Server Database

If you choose to export the SQL log file queries directly to SQL Server database then you need to provide the valid database credentials like: server name, database name, username and its password.

Note: Export the data on some other location in SQL Server in order to avoid the overwriting of existing database

compatible sql scripts

SQL Server Compatible SQL Scripts

If you want to move recovered data to some other SQL Server database then it is recommended to export the SQL log file queries in SQL Server compatible SQL scripts. This SQL script can be used to export the data on any SQL Server as per your requirement. read more

export tables

Export Selective Tables

While exporting the SQL log file queries, you can check or uncheck the tables to save only selected data. If you want to recover data from any specific table then select and export the specific folders as SQL data base, CSV or as SQL Server compatible script.

sort log file

Option to Sort Log File Elements

An auto sorting option is available within SQL Log Analyzer software to re-arrange order of the list of items. You can sort the elements according to their properties like: transaction, transaction time, table name, transaction name and query.

 

SQL Log Analyzer Screenshots

Watch Live Video of SQL Log Analyzer

Download SQL Log Analyzer Software

sql-log-analyzer-box

Size: 1.9 MB

Version: 2.0

Trial Limitations

Demo Version of SQL Log Analyzer Software allows the users to Preview & Anlyze the Log file (LDF file)

system requirements

  • Hard Disk Space: 5 MB of free hard disk space
Frequently Asked Question

Does the Software Support SQL Server 2012 LDF File?

No, the software does not support SQL server 2012 LDF file. So far, you can open and preview the LDF file of SQL server 2005 and 2008.

I have a laptop installed with Windows 8. Can I run this software on it?

Yes, Windows 8 and all below versions of the Operating System are now supported by the software.

Do I need to have SQL Server environment for using this tool?

SQL Server installation is not needed for analyzing transaction details. However, SQL Server environment is must if you want to export into SQL Server database.

I have a corrupted MDF file while the LDF is healthy. Can I still restore data with this program?

Yes, it's only by processing LDF file that the tool restores data from associated corrupt / inaccessible MDF file.

Can I run this software on SQL Server v2012

No, currently SQL database of 2012 version is not supported. But databases created in SQL Server version 2005, 2008 and 2008 R2 are supported.

Is it possible to view transaction details with only Log Transaction file and no MDF file?

No, without an MDF file the tool will not process LDF file alone. You must have associated MDF file to see transaction details of the respective LDF file.

Will I be able to view deleted transaction with this tool if database records have been deleted?

Yes, regardless of the form of damage caused, the tool gives all transaction info viz. Name of Transaction (Insert, Update or Delete), Name of Table on which transaction was performed, Date && Time of Transaction and performed Query.

Can this tool be used for forensic purpose?

Yes, being a log analysis as well as database recovery program; the software is suitable for forensic usage as well. It gives out all transaction details of SQL database components with date, time and actions performed.

Testimonials

A meager carelessness from SQL Server administrators ended us up with a corrupt SQL database. Coming across the SQL Log Analyzer tool via online search results made us familiar with its excellent facilities that made things easier, precise and guaranteed.

— Vanessa Bruni, Russia

SQL Log Analyzer is one of the finest applications that I have worked with till present date. We had been trying to restore MDF database using LOG files of the same but failed poorly. That's when a client of our organization suggested using this application that demanded No efforts or time.

— Kacy Karren, London

SQL Log Analyzer Order Now
Get an Overview of SQL Log Analyzer Features - FREE and Licensed Version

FEATURES

Add LDF File

Preview & Sort Log Fields

Preview the Row of Selected Transaction

Support SQL Server 2008, 2008 R2 Database & Below Versions

Windows 8 & All Other Previous Windows Version Supported

Export Log File into SQL Server Database

Export into SQL Server Compatible SQL Scripts or CSV

FREE

 

 

 

 

 

 

 

Download

Full Version

 

 

 

 

 

 

 

$149

SQL Log Analyzer faqs