SQL log Analyzer provides a complete detail of transactions that were performed in a database. It includes Transaction, Login Name, Time, Table Name, Transaction Name, Query. Read More
SQL transaction log reader tool not only recover data from sql log file, It also track users activities with whom the database is shared.
Get a preview of deleted records and export into three different ways i.e SQL Server Database, .sql scripts file & .csv file format.
Step 1: Launch SQL Log Analyzer. A window like this will appear on your screen
Step 2: In the navigation bar at the top, click on 'Open' button for scanning Options
Step 3: Here user will get two options for viewing SQL Server transaction logs:
Online DB Option: Fetech the transaction logs from Live SQL Server
Offline DB Option: Analyze SQL Server Transaction logs from .ldf file
Step 4: In Online option; After filling the required information, click On Ok to proceed for scan.
Step 5: Software shows the scanning details such as; No. of Records, No. of Inserts, No. of Updates, & No. of Deletes. Click Ok to proceed.
Step 6: Preview the transaction logs for each table available in the database.
Step 7: Now, from the top left; check the tables that you want to export and click on export to save
Step 8: Check the transaction that you want to export: INSERT, UPDATE & DELETE.
Step 9: Select the date range to save the specific date range transactions
Step 10: Export to as: SQL Server Database, SQL Compatible Scripts or CSV
Step 11: Enter Database credentials, only if you want to export as a SQL Server Database
Step 12: Choose the destination database options: Create New Database or Export to Existing Database
Step 13: Provide the Database Name, If you want to save as Create New Database
Step 14: Click on Export to begin the export procedure
Step 15: Click OK on the window that appears on screen prompting you about the successful completion of export
Step 16: A prompt up window will open that will ask Do you want to Export the Details to a .csv file? Click Yes if you want
Great tool, My SQL Server database was inaccessible and corrupted I was not able to open SQL server database transaction log file, but when I repair SQL transaction log file with this SQL Server log recovery tool I can easily access its data.
I like the tool because of its simplicity. I have used so many tools to recover deleted data from transaction log, but failed every time because of the complexity of those tools. When I used SQL log file viewer, I have easily export and recovered my SQL Server data without any effort and time.