News We Recently Launched AD Migrator and AD Reporter.
Analyze SQL Server Transaction Log details in the simplest manner Via SQL Log Analyzer Tool. Just go through the Step-by-Step instructions to understand the working process of software.
Open & launch the SQL Log Analyzer tool.
Click Start » All Programs » SysTools SQL Log Analyzer
Here user will get two options to add file to the software:
Online Database Option
If user select Online DB Option, Software allow you to select the Server Name from available list. If the Server Name not available in the list then, you can enter it manually. Afterward, choose Authentication and click on Select Database option drop down arrow to opt for desired database.
You can view the complete scanning details such as; No. of Records, No. of Inserts, No. of Updates, & No. of Deletes. Click OK to proceed.
Select any of the listed Tables in order to preview & analyze the corresponding log entries of operations performed on the database.
Click on the Transaction field name to sort the list of transactions in ascending or descending order.
Similarly, you can sort the table fields according to the Time, when a particular transaction was executed.
Export Log Files:
Select the Tables by checking the corresponding checkboxes to export their transactions.
Check the transaction record type checkbox that you want to export: INSERT, UPDATE, and DELETE.
Choose Export Option to Save Records:
1. SQL Server Database: For SQL Server Database you need to fill the credentials.
2. SQL Server Compatible SQL Scripts: Select a location on your local machine for exporting the log files in .sql format.
3. CSV: Similarly, you can export the Log File into CSV (Comma Separated Values) format.
Enter Database credentials: Server Name & Authentication type. If you are using SQL Server Authentication then, fill the appropriate User Name & Password.
Select the destination database to export On: Create New Database or Export to Existing Database
Click OK on the window that appears on screen prompting you about the successful completion of export.
A prompt up window will open that will ask - Do you want to Export the Details to a .csv file? Click Yes if you want.
Open & launch the SQL Log Analyzer tool.
Click Start » All Programs » SysTools SQL Log Analyzer
Here user will get two options to add file to the software:
Offline Database Option
If users select Offline DB Option, click on the LDF File Path Browse button to load the Log file.
Select the LDF file & click on Open.
If database .mdf file is corrupted, the software enables this option to select the version of SQL database file.
User can Check Get all Login\User names checkbox if you want to identify who has done the transaction (Optional). For this you need to provide the Login Credentials (Server Name, User Name and Password).
The software will ask you to export the details to a CSV file. If you want to save then click on Yes.
After Exporting Log File:
Navigate to the destination location chosen to save the output to check the results.
Free Download SQL Log Analyzer Download Now