SQL Server Log Analyzer to Read Transaction Log File
Every SQL Server database is associated with one database file, i.e. MDF and its LDF file where all the transactions or database modifications made by any transaction are stored. It is necessary for each user to keep their database files healthy. An LDF file stores enough information to recover the database in case of any mishaps or data loss. Due to the recovery requirements, user needs to analyze the LDF file and its contents. In this review, we will be discussing about a third party tool, SQL Server Log Analyzer used for LDF file analysis.
What is SQL Server Log Analyzer?
SQL Server Log Analyzer is a tool that has been developed to make users analyze the SQL Server Log file transaction to detect the possible cause of SQL Server database corruption. The Software is a Windows-based Analyzer that comes with small installation size and easy to use interface.
The SQL Log Analyzer is available for free download on the company’s website to check the efficiency of the tool. However, the use of the trial version is restricted in terms of some functionality.
The upgraded version of the tool can be purchased at the cost of $299 from the website of the company, which offers complete functionalities by overcoming the limitation of the demo version.
How the Tool functions?
First, we will download the SQL Server Log Analyzer software from the company’s official website. User can choose either the free version or the License version according to their needs.
Double-click on the setup of the tool downloaded to install it. A pop up will be shown with three options: Buy to purchase the License version, Activate to register the license after purchase and Continue Demo to use the trial version.
Let us understand the working of the SQL Server Log Analyzer in depth. The steps to analyze the SQL Server Log Transaction file using the tool are as follows:
The software will be launched after selecting any of the options above. Click on ‘Open’ to add the LDF and MDF files to the application.
Browse the location in the system where the LDF file is present to add it. Add the corresponding MDF file manually or it will be added after auto-detection if both files are stored in same location. Click on ‘OK’ to start the LDF analysis.
After completion, a report will be generated containing details like number of records, number of inserts, number of updates, etc. Click on ‘OK’ again.
The tool will give preview of all the contents of LDF file and detailed information of each table will be displayed like Transaction name, date and time, table name, etc.
After studying the preview, click on any desired transaction manually or select all to export using ‘Export’ option present in the top menu.
Choose the desired Export options: SQL Server database – Database credentials needed for this option, SQL Server compatible Scripts – Move data to another SQL Server database and CSV – export data into Comma Separated values format.
Select the desired transaction type checkbox among the options: INSERT, UPDATE or DELETE. In addition, Apply Date filter option can be used to export data on the selected date ranges.
Browse the location in the system to save the exported data and click on Export. After completion,complete status report will be displayed. The presence of exported data can be verified after going to the location specified.
Multiple Export Options Supported
No SQL Server installation Needed
Works for Offline SQL database
MDF File needed for LDF analysis
Keeping in mind the positive as well as the negative aspects of the software, we can conclude that the SQL Server Log Analyzer is a great helping hand for SQL Server Database user to read SQL server transaction log. It will help them to re-visit the transactions occurred earlier to check if there is any damaged/interrupted transaction that has made the database corrupted. It can be rated as 9.7 out of 10 as it has few limitations such as it works only for offline SQL database & MDF is required for analysis of LDF file.