SysTools SQL Log Analyzer 4.0
SysTools SQL Log Analyzer 4.0
SQL Log Analyzer tool allows user to connect to online SQL Server Database using proper credentials to automatically fetch the database & its records. This allows user to preview all the records within the database such as INSERT, UPDATE, DELETE etc.This inbuilt feature provides user to connect to Live Database for accessing the transaction logs.
Analyze SQL log file transactions & quickly perform SQL ldf file recovery
Preview .ldf Activity: Transaction, Time, Name, Table Name, & Query
Read & Analyze All Transactions like: INSERT, DELETE, UPDATE etc.
Supported Data Types: Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography data types.
Quick Scan, View LDF file and Auto locate associated MDF file
Provides support to fetch & view records from Live database
Recover Deleted Records if database is in Simple Recovery Mode.
Option to Filter & Export as SQL Database, as SQL Script or as CSV File
Provides Support to Analyze Multiple NDF File data
MDF File is required to analyze the database
The tool works both online & offline SQL database environment
Supported Unicode (collation) data tables after export
Supports SQL Server 2016, 2014, 2012, 2008 and SQL Server 2005 LDF Files
Analyze all SQL Log Transaction
SQL LDF Viewer allows you to open, read 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 LDF Data Recovery
To avoid complete scanning of corrupt SQL Server database for recovery SQL LDF Reader 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 into SQL Server and SQL Server compatible format; after thorough analysis.
Preview All SQL LDF (log) Transactions
SQL LDF Reader scans and loads all the tables present in SQL database and generates a preview for all transaction activity saved in LDF file. It helps to view SQL Server transaction log with fields like: Transaction, transaction time, Table name and query. You can view the records with Login Name Authentication for Insert, Delete, Update etc with their details such as; class, id, name and status.
3 Options to Export SQL Log File
SQL LDF File Reader 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.
Export as SQL Server Database
If you choose to export the SQL ldf 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
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 ldf 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.
Add LDF & MDF File
Using the LDF Viewer software you can add single SQL 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 database, you have to provide the LOG details for last backup of your SQL data.
Explore Multiple NDF File Data
This SQL Log Analyzer tool provides user to explore multiple NDF Files. This feature within the software provides user to analyze multiple Secondary database file data to preview all the records within the .ndf file.
Option to Sort Log File Elements
An auto sorting option is available within SQL LDF file Reader 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.
Recover Database of Latest Versions
Analyzed SQL Log file can be used for the recovery of the corresponding corrupt database. The software is supportive to the latest versions of SQL Server.You can also recover deleted records if the database is in Simple Recovery Mode. Thus, a database of 2012, 2014 & 2016 SQL Server versions can also be recovered successfully.
Export Selective Tables
While exporting the SQL ldf file queries, you can check or uncheck the tables to save only selected data. If you want to recover sql ldf file data from any specific table then select and export the specific folders as SQL data base, CSV or as SQL Server compatible script.
Log File Forensics without SQL Server
SQL Server Log file analyzer promotes the forensic analysis of Log files for examination of SQL Server activities. The software is a standalone tool to view SQL transaction log and doesn't need Microsoft SQL Server installed on the machine for analysis.
Support Advance SQL Data Types
Now the sql log file viewer also supports the advance data type like Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography data types for the advance forensics of SQL Server 2016 & below versions transaction log files.
Save And Load Scanned Log File
The scanning of loaded log file can be saved for future use. A scanned copy of Log can be saved as an STR file to avoid rescanning it every time there is a need. Just load the saved STR to work on the scanned Log file.
Supports 64 Bit Windows Versions
Being a Windows based application; all versions of Windows OS are fully supported, including Windows XP, Windows 7, Windows 8, Windows 8.1 and the latest Windows 10. Both; 32 Bit and 64 Bit of Windows Operating System editions are supported.