Improved performance New

Compressed backup auditing New
Use natively compressed database and transaction log backups as auditing sources

Visual results filtering New  
Selectively limit the auditing results that will be displayed based on the time the change occurred, the user who made it, the objects which were affected and more

SQL Server 2012 support New
Read transaction logs created in SQL Server 2012. Restore SQL Server 2012 objects and data. Audit and undo changes made on FileTables, sequences and columnstore indexes 

Improved scalability New
Fully leverage the increased memory limit and performance boosts provided by the x64 architecture. Navigate through up to 10 million operations at once

FIPS support New
Audit database changes on FIPS compliant systems

Fast results access New
View the captured changes without waiting for the auditing sources to be fully processed

Support for additional SQL Server objects, types and operations New
Audit and undo changes made on SPARSE columns, vardecimal data or by SELECT INTO operations

Compressed tables support New
Capture changes made on tables with page and row compression

Passive auditing
Leverage the comprehensive auditing information already contained within the transaction log for virtually zero-overhead auditing

Transaction log backup support 
Read the online SQL database transaction log, detached LDFs and native or compressed transaction log backups

Smart log reading 
Automatically identify the optimal method for transaction log reading for peak performance

Repeatable sessions 
Save your options to a project for instant re-execution of the same session

Multiple report and output formats 
Display the transaction log information in HTML or export to CSV, XML or SQL

Row level export 
Copy one or more rows from the result set to Excel

Operational undo or redo 
Selectively view or script one or all operations in a transaction

Result search
Find any value from any field in the transaction log

Information filtering 
Display only the transactions that meet the filter criteria that you specify

Detailed login info 
Find out the name of the login, computer and of the application used to make the change

Row History 
View all historical modifications to a specific row of data

Full operation and transaction detail 
View granular details for every operation and transaction recorded in the transaction log

Unattended execution
Read transaction log files unattended during off peak hours via the CLI, minimizing the overhead on your server

Support for all SQL Server versions
Read transaction logs created in SQL Server 2012, 2008 R2, 2008, 2005 and 2000

Hardware    

• Dual Core 2.0 GHz CPU
• 4 GB memory
• 500 MB disk space

SQL Server    
SQL Server 2005 and higher [1]

OS    
Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Port    
TCP ports 60408 and 65100 on all SQL Server instances and on ApexSQL Log installed machine

Software    
.NET Framework 4.7.2 or higher

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

[1] See Supported systems for exact version support

ApexSQL DBA
Automate critical tasks for database administration

ApexSQL Audit
Track data changes to SQL databases

ApexSQL Job
Manage SQL jobs, including history, scheduling and alerts

ApexSQL Manage
Discover and manage SQL Server instances, perform health checks, documentation and comparison

ApexSQL Defrag
Monitor and manage SQL index defragmentation in SQL Server

ApexSQL Recover
Recover deleted, dropped, corrupted or lost data

ApexSQL Developer 
Integrate database changes and automate deployments

ApexSQL Build
Build, update and deploy SQL databases

ApexSQL Data Diff
Compare and synchronize SQL database data

ApexSQL Diff
Compare and synchronize SQL database objects

ApexSQL Doc
Document SQL instances, databases and SSIS packages

ApexSQL Script
Script and package SQL databases

ApexSQL Analyze
Analyzing graphical database object dependencies. Diagram exports and reports in various formats. External database analysis. Impact analysis

ApexSQL Enforce
Database development best practices review and enforcement. Includes reporting and CLI automation

ApexSQL Generate
Test data generation. Pre and post processing scripts and CLI automation

ApexSQL Pump
Import and export data to and from the database in various file formats. Includes CLI automation

ApexSQL Source Control
Database objects version controlling using shared or dedicated development model, including the check out and lock policies and conflict resolution respectively

ApexSQL Trigger
Audit DML and DDL database changes and create an exportable reports

ApexSQL Unit Test
SQL database unit test management and execution, including automatic test execution and exporting results using the CLI