How to Analyze SQL Server Log File
Now analyze SQL Server transaction log details in the simplest manner via SQL Log Analyzer Tool. You just need to follow this "How it Works" section to understand the working process of the tool.
Here user will get two options to add file to the software:
- Online DB Option
- Offline DB Option
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, then choose Authentication and click on drop down arrow to Select Database.
Similarly, you can sort the table fields according to the Time, when a particular transaction was executed.
Export Log Files:
Select the Tables using checkboxes provided against each, 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.
Select the LDF file & click on Open.