Watch the working preview of software and simply follow the steps :
step 1
Install & run the SQL Log Explorer Tool and click Open.
step 2
Software provides you 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 drop down list. If the Server Name is not showing in the list ,then you can enter it manually, Choose Authentication mode and click on drop down arrow to Select Database.
step 3
After filling all details , Click Ok.
step 4
Click Ok once scanning is done.
step 5
Offline Database Option
If user select Offline DB Option, click on the Browse button to load the LDF file.
step 6
Select the LDF file and Click Open.
step 7
Software gives you option to select the version of mdf file if the file is corrupted.
step 8
User can Check all Login\User names details by clicking on 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).
step 9
Click on Fetch User to retrieve all the users of Server.
step 10
Scanning completed successfully pop up will appear.
step 11
Now view scanning details and click on Ok button.
step 12
You can save scanned file into .str file format.
step 13
Save the the .str file into desired location.
step 14
Click Ok button, once the file is saved successfully
step 15
Preview the log file data.
step 16
Select the table which you want to export.
step 17
Click on Export button to save log file data.
step 18
Export data according to transaction ie. Insert, Update, Delete.
step 19
You can also export transaction records of selected date using Date Filters option.
step 20
Select the export option as per your need. Software gives you 3 different options for exporting:
step 21
Browse the Destination location to save the log file data.
step 22
Select a preferred destination location and click Ok.
step 23
Click on Export button.
step 24
'Export Completed' window will pop up confirming the successful export process.
step 25
Now you can see the complete export report and click on Ok.
step 26
Software will ask you to export the details to a CSV file. If you want to save, then click on Yes.
step 27
Select the folder where you want to save. Click on Ok
step 28
You can open & preview the CSV file on your system.
step 29
After Exporting Log File,navigate to the destination location chosen to save the output to check the results.
step 30
Preview the .sql file with SQL Server Database.