Stellar Log Analyzer for MS SQL/4. Working with the Software/4.3. Save LDF File/4.3.1. Save Log Tables Data

4.3.1. Save Log Tables Data

If you only want to save the data of the log (LDF) file thenLog Tables Data应该使用保存选项。

Steps to save Log Tables Data:

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. SeeAnalyze LDF Fileto know how to analyze the selected log (LDF) file.
4. Click onSaveicon from theFileribbonOR选择Saveoption from theQuick Access toolbarto save the LDF file.
5. ASave Aswindow appears. SelectLog Tables DatafromSave Logsection.

6. Check against the required checkboxes, underSelect Transactions(Insert, UpdateorDelete)that you want to save in the database.
7. Check againstApply date rangecheckbox, if you want to apply date filters to save the results from a particular time period. ChooseFromtoTodates between which you want to apply the filter.
8. There are four different file formats to save LDF file. Choose any one of them fromSave Assection.
   1. MDF
   2. CSV
   3. HTML
   4. XLS

Steps to save Log Tables Datato MDF 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. SeeAnalyze LDF Fileto know how to analyze the selected log LDF file.
4. Click onSaveicon from theFileribbonOR选择Saveoption from theQuick Access toolbarto save the LDF file.
5. ASave Aswindow appears. SelectLog Tables DatafromSave Logsection.

6. Check against the required checkboxes, underSelect Transactions(Insert, UpdateorDelete)that you want to save in the database.
7. Check againstApply date rangecheckbox, if you want to apply date filters to save the results from a particular time period. ChooseFromtoTodates between which you want to apply the filter.
8. ChooseMDFoption fromSave Assection.
9. There are two saving options, underSaving Optionsection:
   1. New Database:You can select this option, if you want to save the Log Tables Data in a new database.

1. UnderConnect to Serverfill the following entries:

   1. EnterServer Name \ Instance Name

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

• If the authentication method selected isWindows Authentication, you need not enter the user name and password.
• If the selected authentication method isSQL Server Authentication, enter the serverUsernameandPassword.

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. ClickBrowseand select the location where you want to save your database.

2. After filling the information, clickSaveto save theLog Tables Data to MDF file format.

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

4. ClickOKto finish the process.

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

1. UnderConnect to Serverfill the following entries:

1. EnterServer Name \ Instance Name

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

• If the authentication method selected isWindows Authentication, you need not enter the user name and password.
• If the selected authentication method isSQL Server Authentication, enter the serverUsernameandPassword.

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

2. ClickSaveto 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. ClickOKto finish the process.

Note: If you want to refresh theExisting databaselist,click onRefresh.

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

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. SeeAnalyze LDF Fileto know how to analyze the selected log LDF file.
4. Click onSaveicon from theFileribbonOR选择Saveoption from theQuick Access toolbarto save the LDF file.
5. ASave Aswindow appears. SelectLog Tables DatafromSave Logsection.

6. Check against the required checkboxes, underSelect Transactions(Insert, UpdateorDelete)that you want to save in the database.
7. Check againstApply date rangecheckbox, if you want to apply date filters to save the results from a particular time period. ChooseFromtoTodates between which you want to apply the filter.
8. Choose the desired format(CSV, HTMLorXLS)fromSave Assection.
9. ClickBrowseto save the LDF file to a destination path.

Note: Check againstAutomatically open the destination folder after savingcheckbox if you want to immediately open the saved LDF file folder.

10. ClickSaveto save the Log Tables Data to(CSV, HTMLorXLS)file format.
11. After successful completion, a dialog box appears with a message, "File saved at the desired path".

12. ClickOKto finish the process.