SysTools SQL Log Analyzer is a Windows based software application that allows you to view and read the SQL Server database transaction log files. The DML transaction statements - INSERT, UPDATE, DELETE can be analyzed through the tool and the records can be saved into tabular form in CSV file. Also, for quick recovery of database, software gives option to add corrupt MDF file and its corresponding LDF file. The recovered data can be exported into SQL Server or SQL compatible scripts.
1) SQL Log (LDF) file can be opened and viewed within software interface. Related details for the transactions like table name, the query, transaction name/time, can be checked in the tool. If needed, this detail can be exported into CSV file.
2) For quick recovery of database, MDF and LDF files can be added to the tool. If the MDF and LDF are stored at same location, the software will auto-detect it. However, for MDF file at separate location, it has to be manually added.
3) The recovered data from MDF file can be exported to live SQL Server. The recovered data along with schema can be saved into SQL compatible scripts for later import to Server.
4) To export database to SQL Server, the location to save DB, the targeted server/DB details-server name, database name, username and password has to be provided.
5) Software works with all versions of MS SQL Server. LDF and MDF file recovery for SQL 2000, 2005, 2008, 2012 and 2014 is supported by the tool.
Limitations:
Limited functionality
Comments not found