Process to Know How to Analyze SQL Server Log (.ldf) Files

Go to Start menu » Programs » SysTools SQL Server Recovery Manager Tool » SysTools SQL Server Recovery Manager Software
Choose 'Analyze SQL Server Log (.ldf) File' module from the software panel.

Click on Open to add the SQL Log (.ldf) file to be analyzed.

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.

Now, choose the desired database by clicking the drop down arrow and click on Ok button.

Offline Database Option

If users select Offline DB Option, click on the LDF File Path Browse button to load the Log file.

Select the LDF file & click on Open.

User can Check Get all Login\User names 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).

A prompt up window will open saying Scanning completed successfully.

Now view scanning details and click on Ok button.

Click on Save if you want to save scanned file into .str file format.

Save the the .str file into desired location.

Preview of log file data.

Select a Table and preview / analyze the log file.

Arrange the transaction attributes upside-down or vice versa to sort them in an ascending / descending order accordingly:

You can sort the information of transactions by Login Name.

You can sort the table fields according to the transaction time:

Sort Log file according to Table Name

Sort details according to Transaction Name:

Preview the row of selected transaction:

After selecting the table(s), click on Export button from the software menu:

Select Insert, Update, and/or Delete record using check boxes, and apply filter on the transaction type to be exported.

Similarly, apply "Date Filter" to export records of a selected date range.

Choose Export Type to Save Records:

1. SQL Server Database: For SQL Server Database you need to provide server credentials: Server Name, Database Name, and Username & Password.
2. SQL Server Compatible SQL Scripts: Select a location on your machine to save transactions as .sql file.
3. CSV: Similarly, select a folder or path on the local machine to save Log File as a CSV file.

Enter Database credentials: choose Server Name by clicking on drop down arrow & 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. Then, Provide the Database Name, If you want to save as Create New Database and Click on Export

Select SQL Server Compatible SQL Scripts, if you want to export as a .sql script format.

Now browse and select a location for saving the output.

Select the destination location and click OK:

Click on Export button to begin the process:

Once the export process completes, click OK on the pop up window notifying the same.

Take a look at the complete status report.

After Exporting Log File navigate to the location where you have saved the file after conversion:

Select CSV File Format if you want to export as .csv file.

Browse and select the location for saving the output file.

Choose destination path and click OK.

Now, click on Exportto begin the process.

Once export process is completed, click OK.

Now, look at the complete export report.