If the recovery model of the database is 'Simple', a warning message is displayed.Ĭhange the recovery model to 'Full' from Database Properties In a location other than the SQL Server default folders.ģ)The database is attached to the server again.

Log Selection wizardġ)In the Log selection wizard, select the authentication method and click 'Next'Ģ) The ApexSQL Log can attach itself to the live logs of the database or log backups or the detached logs.ĭetached Logs | Detached logs are taken by the following steps:ġ) The database is detached from the server.Ģ) A backup of the LDF file is taken by copying the LDF file The installation procedure is very simple(as usual).The user can click the 'Next' button and finish the installation within a minute. The ApexSQL Log evaluation version can be obtained from.

Can audit multiple transaction logs of different databases at a time.i.e The user can attach the tool to 'Adventure works' database and the same time can attach to the 'pubs' database, thus enabling simultaneous auditing.

Data can be recovered to a large extent, even if the recovery model is Simple(Provided the time between the data loss and recovery is small).

The tool can attach itself to live logs or log backups or detached logs.

The tool does not need log backups for data recovery.

Recovery wizard with 5 recovery options.

Export records in the XML format, excel and SQL script format.

Support for SQL Server 2005(SQL Server 2000 and 7.0 are still supported).

Market for transactional analysis which has support for SQL Server 2005.TheĪpex SQL Log added the support for SQL Server 2005 in its release 1.90(Feb 22Ģ006).The current version of the tool is 2005.03

Apex SQL Log version 2005 is the only tool available in the

Apex sql analyzer