SysTools SQL Log Analyzer is designed to read and analyze Microsoft SQL Server transaction log (.ldf) files, providing insights into database changes. It allows users to open, read, and analyze all SQL transactions, including Insert, Update, and Delete operations. The tool aids in restoring modified databases back into SQL Server and helps forensic investigators track who modified SQL table records in detail. It performs a quick scan to deeply examine log files, offering full visibility into database records. Users can analyze transaction operations without requiring the MS SQL Server application. The software supports both online and offline SQL database environments, allowing users to fetch and view records from a live SQL database. It also supports advanced SQL data types such as Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry, and geography. Dynamic filters enable the export of selective transaction records after complete analysis. The tool displays LDF information in SQL Scripts, CSV files, or directly exports it to any SQL Server database. It can auto-locate MDF files to read the schema of scanned log files while opting for the offline DB option and provides support for the Unicode (Collation) property after exporting the database. It supports MS SQL Server versions 2022, 2019, 2017, 2016, 2014, 2012, 2008, and SQL Server 2005 LDF.

Features & Benefits

• Deep Examination of SQL Log File
  • Provides detailed insights into every transaction in a human-readable format.
• Full Visibility to Live Database Records
  • Connects to Online SQL Server Database to automatically fetch and preview database records.
• Analyze all SQL Log Transactions
  • Opens, reads, and previews complete log activity, including Transaction Name, Login Name, Transaction Time, and Table Name.
• SQL LDF Data Corruption Fix
  • Helps avoid complete scanning of corrupt SQL Server databases by scanning and exporting data from the last backup of the SQL log file with the associated MDF file.
• Isolate Single Log Transactions
  • Scans and loads all tables, generating a preview of transaction activity and allowing users to view specific records with column names.
• 3 Options to Export SQL Log File
  • Exports 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
• Facility to Add LDF & MDF File
  • Automatically detects associated MDF files if present at the same location as the LDF file.
• Complete Log (.ldf) File Investigation
  • Views any database operation saved in MDF or NDF files, if transaction details are available in the log file.
• Option to Sort Log File Elements
  • Re-arranges the order of items according to properties like Transaction, Transaction Time, Table Name, Transaction Name, and Query.
• Export Selective Tables
  • Allows users to check or uncheck tables to save only selected data during export.
• Log File Forensics Without SQL Server
  • Functions as a standalone tool to view log files without requiring Microsoft SQL Server installation.
• Support For Advance SQL Data Types
  • Supports advanced data types like Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography for advanced forensics.
• Option to Save & Load Scanned Log File
  • Saves scanned versions of transaction log files in STR format for future use, avoiding rescanning.
• Read LDF On 64 Bit Windows Versions
  • Supports all versions of Windows Operating System, including Windows 11 (64-bit), Windows 10, Windows 8.1, Windows 8, Windows 7, Windows XP.