Publisher review:ApexSQL Log has the ability to read online logs, detached logs and log backups. ApexSQL Log has the ability to read online logs, detached logs and log backups.Audit SQL Server and Recover Lost Data in one incredibly versatile tool!
- ApexSQL Log is a powerful Microsoft SQL Server log auditing and recovery tool that analyzes SQL Server's own transaction log to display information on data changes, including user (nt user), computer and application 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.
- Ooops - wish you could UNDO that Update statement without a where clause!? ApexSQL Log is the Industry's most powerful recovery options for SQL Server 2005. We've helped customers recover single statements to 350 GB databases! No backups required.
- 64 bit support
ApexSQL Log has the ability to read online logs, detached logs and log backups. It allows users to recover dropped/truncated tables, tracks individual row history, and can generate UNDO and REDO scripts on the fly. Log also features powerful filtering abilities to help users locate and isolate specific transactions quickly and easily.
Features
- 64 bit support
- SQL Server 2005 Support (SQL Server 7 and 2000 still supported)
- Recovery Wizard - recover dropped, deleted, truncated and lost data as well as dropped objects
- New Log Creation Wizard
- Regular Expression Table filter
- Column level Grid filter - for complex, compound filtering post log reading
- Many grid new grid features - compound sorting and grouping, column picker, check all, collapse/expand, improved grid navigation etc
- Significantly improved engine
- Automatic update feature
- Filter Wizard with XML based filter profiles
- Command Line Interface
- Data Recovery
- Database Definition Language (DDL) auditing. Changes to system tables can now be exported as DDL statements from client and from command line
- NT user name, application name and client host auditing
- Multi-threaded UI showing operations as they are found.
- Automatic UPDATE reconstruction
- Batch/command line exporting
- Read detached log files.
- Generation of UNDO/REDO scripts.
- Live log support.
- XML export.
- Passively audit using transaction log backups or live log files what has been inserted, updated (both before and after), and deleted from every table in your database.
- Powerful filtering, grouping and sorting of log data.
- View field level data for each row in insert, update and delete. View history of changes of a row.
- Audit seamlessly multiple transaction log backups or live log files.
- Printing of log and history views.
- State of the art interface with Multiple Themes, panel docking, customizable toolbars
Requirements: · Microsoft SQL Server versions 7, 2000 or 2005 · Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater · Microsoft .NET Framework 2.0 · Windows 2000 · Windows XP · Windows 2003 · Windows Vista (32 bit)
ApexSQL Log is a ASP.NET script for Database Tools scripts design by Apex SQL Tools.
It runs on following operating system: Windows.
ApexSQL Log has the ability to read online logs, detached logs and log backups.
Operating system:Windows
ApexSQL Log script details 
