Stellar Log Analyzer for MS SQL analyzes and tracks manipulated data, including the Insert, Delete, and Update operations performed on the database. It also analyzes deleted or dropped table data. After completing the analysis, the tool displays a preview of the log tables data and transactions to gather the forensic details. The software displays an enhanced preview of all the transactions performed on SQL database tables in a tree format. The user can sort and view the transactions based on Transaction Type, Transaction Name, Table Name, and Query. Also, the user can view the complete query of a transaction by double-clicking on it. The tool allows the user to save deleted transactions to a new database. The feature helps in the seamless creation of a database containing all the recovered items. The user can also choose to save the recovered data to an existing database connected to the SQL Server.

The software auto-detects an MDF file associated with the LDF file if the files are saved in the same location. If the MDF file is renamed or saved at a different location, the user can use the Select MDF option to search for the file. The tool also provides the Find option to search for LDF files. The tool allows the user to save the log tables data and log transactions of a SQL database. The user can save log tables data in MDF, CSV, HTML, and XLS file formats. It supports CSV, HTML, and XLS file formats to save the log transactions and provides a date range filter to save the transactions for a specified period. The tool generates a detailed log report of the LDF and MDF file saving process. It comprises details like the start and end time of the saving process, selected database version, database collation, database file size, log file size, and the number of tables available within a database.