ApexSQL Log is a Microsoft SQL Server log auditing and recovery tool that analyzes SQL Server's own transaction log to display information on data changes, including computers and applications where the change originated.
Since ApexSQL Log reads the transaction log, no database overhead or the use of database triggers is required and audits can be done on changes made even before the tool was installed.
ApexSQL Log reads online logs, detached logs and log backups. It allows users to recover dropped/truncated tables, and it tracks individual row history and can generate UNDO and REDO scripts on the fly. The tool also has filtering abilities to help users locate and isolate specific transactions. It includes CLI and SQL Server 2005 support.
ApexSQL Log's latest version includes these new features:
- 64-bit support
- SQL Server 2005 support (SQL Server 7.0 and 2000 still supported)
- Recovery Wizard, which recovers dropped, deleted, truncated and lost data as well as dropped objects
- Log Creation Wizard
- Regular Expression Table filter
- Column level grid filter for complex, compound filtering post log reading
- Grid features -- compound sorting and grouping, column picker, check all, collapse/expand and improved grid navigation
- Significantly improved engine
- Automatic update feature
- Filter Wizard with XML-based filter profiles
System requirements: Software prerequisites -- Microsoft SQL Server versions 7.0, 2000 or 2005. Required components not included with installation -- Microsoft ActiveX Data Access Objects Library 2.8 or greater, Microsoft .NET Framework 2.0. Compatible operating systems -- Windows 2000, XP and 2003, Windows Vista (32-bit). Compatible with 64-bit OS versions (except IA64 version of SQL Server or any SQL Server version running on Itanium hardware). Pentium-class processor 600 MHz or higher, 512 MB RAM (256 MB minimum). 100 MB free disk space preferred.
Pricing: ApexSQL Log + no maintenance $999, 1 license $999, 2-4 licenses $799, 5-9 licenses $699, 10+ licenses $599, site license $6,593. ApexSQL Log + 1 yr. maintenance $1,249, 1 license $1,249, 2-4 licenses $999, 5-9 licenses $874, 10+ licenses $749, site license $8,243. ApexSQL Log + 2 yr. maintenance $1,399, 1 license $1,399, 2-4 licenses $1,119, 5-9 licenses $979, 10+ licenses $839, site license $9,233. ApexSQL Log + 3 yr. maintenance $1,449, 1 license $1,449, 2-4 licenses $1,159, 5-9 licenses $1,014, 10+ licenses $869, site license $9,563.