Stellar Log Analyzer for MS SQL

toogle
Stellar Log Analyzer for MS SQL / 4. Working with the Software / 4.2. Analyze LDF File

4.2. Analyze LDF File

With Stellar Log Analyzer for MS SQL you can view complete transactions and log details of any log (LDF) file. The details can be sorted according to the transaction type, time, user, transaction name etc of the transactions. With this software you can also view the query details and records of any particular transaction (Insert, Delete or Update).

Note: Perform analysis process on the copy of database and log file. Also make sure MS SQL Server service is running during saving process of Log Tables Data.

Steps to analyze LDF file:

  1. Run Stellar Log Analyzer for MS SQL.

Stellar Help

  1. See Select or Find MS SQL Log (LDF) File to know how to select/find the log (LDF) file.

  2. After selection of file, Analyze button is enabled, click it to start the process. 

  3. After successful analyzing, a dialog box with the message appears, "Analysis of selected log completed".

Stellar Help

  1. Click OK to finish the process. 

  2. All the tables of the selected log file will be displayed on the left pane of the user interface. Select the desired table to view its corresponding log transactions. The transactions of the selected table are displayed on the right pane of the user interface.

Stellar Help

  1. The log transactions can be sorted according to Transaction Type, Time, User, Transaction Name, Table Name and Query.

Note: To find specific item in the left pane of the tree structure, use Find option from File ribbon, refer to Find Specific Item in Tree.

  1. To view the transaction detail, double click on a particular transaction from the right pane. A Query Detail window appears with the transaction detail i.e. Transaction Type, Transaction Name, Transaction Time, and Transaction Table.

  2. Click Close to close the Query Detail window. 

Stellar Help

  1. Also, at the bottom under Data View pane the transaction data of the selected transaction is shown. Transaction Type are of following types:

    1. Insert: The data that is inserted in the table is shown.

    2. Update: The data that is replaced with the old data in the table is shown. 

    3. Delete: The data that is removed from the table is shown. 

Stellar Help

The software provides options to save LDF file, to know more refer to Save LDF File.