Know How SQL Log Analyzer Works

1. Download the software setup >> Install & Open SQL Log Analyzer.
   
   
2. Click on Open tab to import LDF file.
   
3. Browse LDF file.
   
4. Select LDF file & click on "Open" button.
   
5. Now select associated MDF file & Click "Ok" Button.
   
6. Now you can view the log data associate to each table.
   
7. You can sort elements according to transactions, Time, Table Name, Transaction Name & Query.
   
8. View the details of selected row.
   
9. Select tables to export.
   
10. Now click Export button.
    
11. Select export option to save the analyzed records:
    SQL Server Database: Export data to SQL Server & fill the necessary credentials like SQL Server Name, Database Name, User Name & Password. You can also create new destination database by selecting it.
    SQL Server Compatible SQL Scripts: By using this option, you can export data to local machine for further use.
    CSV: Select CSV option to get report of SQL log data.
    
12. Select filter for Insert, Update & delete Records.
    
13. >Export records according to date wise.
    
14. Select the destination path & click on "Export" button.
    
15. Export completed successfully.