4.3.1. Save Log Tables Data

If you only want to save the data of the log (LDF) file then Log Tables Data save option should be used.

Steps to save Log Tables Data:

1. Run Stellar Log Analyzer for MS SQL.

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

3. See Analyze LDF File to know how to analyze the selected log (LDF) file.

4. Click on Save icon from the File ribbon OR select Save option from the Quick Access toolbar to save the LDF file.

5. A Save As window appears. Select Log Tables Data from Save Log section. 

6. Check against the required checkboxes, under Select Transactions (Insert, Update or Delete) that you want to save in the database.

7. Check against Apply date range checkbox, if you want to apply date filters to save the results from a particular time period. Choose From to To dates between which you want to apply the filter.

8. There are four different file formats to save LDF file. Choose any one of them from Save As section.

   1. MDF

   2. CSV

   3. HTML

   4. XLS  

Steps to save Log Tables Data to MDF file: 

1. Run Stellar Log Analyzer for MS SQL.

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

3. See Analyze LDF File to know how to analyze the selected log LDF file.

4. Click on Save icon from the File ribbon OR select Save option from the Quick Access toolbar to save the LDF file.

5. A Save As window appears. Select Log Tables Data from Save Log section.

6. Check against the required checkboxes, under Select Transactions (Insert, Update or Delete) that you want to save in the database.

7. Check against Apply date range checkbox, if you want to apply date filters to save the results from a particular time period. Choose From to To dates between which you want to apply the filter.

8. Choose MDF option from Save As section.

9. There are two saving options, under Saving Option section:

   1. New Database: You can select this option, if you want to save the Log Tables Data in a new database.

1. Under Connect to Server fill the following entries:

   1. Enter Server Name \ Instance Name

   2. Authentication: Choose the Authentication method from the drop-down list for logging into the server:

• If the authentication method selected is Windows Authentication, you need not enter the user name and password.

• If the selected authentication method is SQL Server Authentication, enter the server Username and Password.

3. Select the location to save the LDF file:

• Default SQL: Saves the database to the default location.

• New: You can save the database at your desired location. Click Browse and select the location where you want to save your database.

2. After filling the information, click Save to save the Log Tables Data to MDF file format.  

3. After successful completion, a dialog box appears with the message, "File saved at the desired path". 

4. Click OK to finish the process.

 

2. Live Database: You can select this option if you want to save Log Tables Data in an existing database.

1. Under Connect to Server fill the following entries:

1. Enter Server Name \ Instance Name

2. Authentication: Choose the Authentication method from the drop-down list for logging into the server:

• If the authentication method selected is Windows Authentication, you need not enter the user name and password.

• If the selected authentication method is SQL Server Authentication, enter the server Username and Password.

3. Existing database: From the drop-down list, select the database in which you want to save the LDF file after analysis.

2. Click Save to save the Log Tables Data to MDF file format.

3. After successful completion, a dialog box appears with a message, "File saved at the desired path". 

4. Click OK to finish the process.

Note: If you want to refresh the Existing database list, click on Refresh. 

Steps to save Log Tables Data to CSV, HTML or XLS file format:

1. Run Stellar Log Analyzer for MS SQL.

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

3. See Analyze LDF File to know how to analyze the selected log LDF file.

4. Click on Save icon from the File ribbon OR select Save option from the Quick Access toolbar to save the LDF file.

5. A Save As window appears. Select Log Tables Data from Save Log section.

6. Check against the required checkboxes, under Select Transactions (Insert, Update or Delete) that you want to save in the database.

7. Check against Apply date range checkbox, if you want to apply date filters to save the results from a particular time period. Choose From to To dates between which you want to apply the filter.

8. Choose the desired format (CSV, HTML or XLS) from Save As section.

9. Click Browse to save the LDF file to a destination path. 

Note: Check against Automatically open the destination folder after saving checkbox if you want to immediately open the saved LDF file folder. 

10. Click Save to save the Log Tables Data to (CSV, HTML or XLS) file format.

11. After successful completion, a dialog box appears with a message, "File saved at the desired path". 

12. Click OK to finish the process.