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

4.2. Analyze LDF File

WithStellar Log Analyzer for MS SQLyou 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. RunStellar Log Analyzer for MS SQL.
2. SeeSelect or Find MS SQL Log (LDF) Fileto know how to select/find the log (LDF) file.
3. After selection of file,Analyzebutton is enabled, click it to start the process.
4. After successful analyzing, a dialog box with the message appears,"Analysis of selected log completed".

5. ClickOKto finish the process.
6. 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.

7. The log transactions can be sorted according toTransaction Type,Time,User,Transaction Name,Table NameandQuery.

• To find specific item in the left pane of the tree structure, useFindoption fromFileribbon, refer toFind Specific Item in Tree.

8. To view the transaction detail, double click on a particular transaction from the right pane. AQuery Detailwindow appears with the transaction detail i.e.Transaction Type,Transaction Name,Transaction Time,andTransaction Table.
9. ClickCloseto close theQuery Detailwindow.

10. Also, at the bottom underData Viewpane the transaction data of the selected transaction is shown.Transaction Typeare 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 software provides options to save LDF file, to know more refer toSave LDF File.