4.1. Select or Find MS SQL Log (LDF) File

Stellar Log Analyzer for MS SQL allows you to select log file (.ldf) and primary data file (.mdf) from your system to analyze all transactions (insert, delete, update, create and drop) completed by the server.

Steps to select LDF and MDF file:

1. Run Stellar Log Analyzer for MS SQL.

2. From File ribbon, click Select Log icon to open Select Log window OR from Quick Access Toolbar, click Select Log option to open Select Log window. 

Note: By default Select Log window appears when the software is launched. 

3. On Select Log window, click Select LDF button to select the required LDF/MDF file.

Note: If MDF and LDF files are stored at the same location, the software will auto-detect MDF file. However, MDF file stored at a different location has to be manually added.

4. An Open window appears. Browse and select the desired file and click on Open button. Selected LDF and MDF paths are reflected in the corresponding boxes.  

 

Steps to find LDF files:

1. From File ribbon, click Select Log icon to open Select Log window OR from Quick Access Toolbar, click Select Log option to open Select Log window. 

Note: By default Select Log window appears when the software is launched. 

2. Click Find to search the LDF files on your system. A Browse for Folder window appears. Select the required drive/folder and click OK.

3. A dialog box appears with the message, "Search completed" with the number of MS SQL Log files found. 

4. Click OK to finish the search process. 

5. The list of LDF files found is shown in the table. Select the required LDF file that needs to be analyzed. 

Note: If you want to clear the search result, click Clear List.

Note: If MDF and LDF files are stored at the same location, the software will auto-detect MDF file. However, MDF file stored at a different location has to be manually added.

After selecting the required files, see how you can Analyze LDF File.