Know How Does SQL Server Transaction Log Viewer Works
View SQL Server Transaction Log Files using SQL Server Transaction Log Viewer Software
After installtion of Software, you can view transaction log files by going to Start menu » Programs » SQL Server Transaction Log Viewer.
Now you have to Click on Open tab to import LDF file.
Browse the LDF files to add the SQL Server Transaction Log Viewer tool.
Now you can select desired LDF file & click on "Open" button.
Select associated MDF file & Click "Ok" Button.
After this you can view the log data associate to each MDF file.
You can Sort the LDF elements according to transactions Query, Time, Table Name & Transaction Name etc.
View the Detailed Properties of selected element.
Now you can Select the required Table which you want to export.
You need to Click on Export button to export the table
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.
You can also Apply the advanced Filter for Insert, Update & delete Records.
You can Select the destination to Export the LDF files.
A dialog box will prompt as "Export Completed Successfully"