Know How SQL Server Transaction Log Viwer Works

STEP 1

After installtion of Software, you can view transaction log files by going to Start menu » Programs » SQL Server Transaction Log Viewer.

open log analyzer

STEP 2

Now you have to Click on Open tab to import LDF file.

import log file

STEP 3

Browse the LDF files to add the SQL Server Transaction Log Viewer tool.

browse ldf file

STEP 4

Now you can select desired LDF file & click on "Open" button.

click to open ldf file

STEP 5

Select associated MDF file & Click "Ok" Button.

select associated mdf file

STEP 6

After this you can view the log data associate to each MDF file.

view log data

STEP 7

You can Sort the LDF elements according to transactions Query, Time, Table Name & Transaction Name etc.

sort elements according transaction

STEP 8

View the Detailed Properties of selected element.

view details of selected element

STEP 9

Now you can Select the required Table which you want to export.

select table to export

STEP 10

You need to Click on Export button to export the table

click to export

STEP 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.

select ldf file export option

STEP 12

You can also Apply the advanced Filter for Insert, Update & delete Records.

Know How Does SQL Server Transaction Log Viewer Works