ApexSQL Log

Read the SQL transaction log

A SQL transaction log reader for forensic auditing and rollback of changes

Overview

• Audit data, schema, and permission changes
• Gain full visibility into your transaction logs
• Rollback or replay any database transaction
• Forensically investigate who changed what and when
• Implement before and after auditing
• View a complete history of row changes
• Reverse inadvertent or malicious database transactions
• Avoid performance overhead and data storage

Features

Transaction visualization View, group, and sort transactions in acustom high performance grid with advanced filtering options.                         Data recovery View deleted and damaged data. Reverseinadvertent or malicious database transactions to repair data. Recover fromspecific data loss/damage without relying on full database restores.                     Before and after auditing View before and after values for updateoperations, who changed what and when the change occurred as well as the fullrow history of row changes.                     Undo or redo Selectively view or script one or alloperations in a transaction and create replay or reroll scripts.       Transaction isolation Isolate specific SQL Server transactionsby user, date, object, change type, and more. Utilize advanced grid searchalgorithms including regular expressions, transaction details and row historysearch.               Multiple report and output formats Display the transaction log informationin grid or export to HTML, CSV, XML, SQL Script, SQL Bulk files or directly toa database.             Detailed login info Find out the name of the login, who andwhen made the change, even before the product was installed as well as granulardetails for every operation and transaction recorded in the transaction log.         Unattended execution Read transaction log files unattendedduring off peak hours via the CLI, minimizing the overhead on your server.           Continuous auditing Carry on with auditing at the exactpoint where the previous auditing session was finished. No more missing and noduplicated data.           Themes Choose between dark, colorful and lightcolored layout

Testimonials

Thank you! You are just great! May I recommend your company and products wherever and whenever you want me to do? ... When we would start using ApexSQL Log I'll purchase it for sure, your service is exceptional!

Georg Untersalmberger

Managing Director

KraftWerk Informationstechnologie GmbH

System requirements

Hardware requirements Dual Core 2.0 GHz CPU

 4 GB memory

 500 MB disk space 

SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Database compatibility level 90 (SQL Server 2005) or higher 

OS Windows Vista/Server 2008 and above

Required  Microsoft .NET Framework 4.5 

Note Native support for the x64 architecture

 Databases secured with Transparent Data Encryption (TDE) cannot be used as a source for auditing/recovery