ApexSQL Log is ready for SQL Server 2012

Raleigh – May 22, 2012 – ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Log. New version fully supports SQL Server 2012 and all of its new objects, properties and enhancements

About ApexSQL Log: ApexSQL Log is an auditing and recovery tool for SQL Server databases which audits, reverts or replays data and object changes that have affected the database, including the ones that have occurred before the product was installed. It restores damaged or missing data and objects and captures information on the user, application and host used to make each change.

For more information visit the ApexSQL Log product page

Here is an overview of what’s supported:

Database auditing

Full support for auditing all SQL Server 2012 databases, including:

  • Contained databases created in SQL Server 2012
  • Non-contained databases created in SQL Server 2012
  • Non-contained databases created in earlier SQL Server versions

Contained databases

Auditing data sources

The following data sources can be used:

  • Online transaction logs
  • Detached transaction log files
  • Transaction log backups
  • Database backups

to audit both non-contained and contained databases. Databases which have been created in earlier SQL Server versions and migrated to SQL Server 2012 can be audited using transaction log and database backups created in SQL Server 2012 as well as detached log files, transaction log and database backups created in earlier SQL Server versions

transaction logs

Now, in addition to non-compressed database and transaction log backups, natively compressed database and transaction log backups can be used as auditing data sources as well

transaction log backups

SQL Server 2012 integration

Captured SQL Server 2012 login data including the user, host and application names are captured and stored into any specified database

specified database

Additionally, all information on audited operations can be exported to a SQL script which can be opened and successfully executed in SQL Server 2012 Management Studio

script editor

Auditing new SQL Server 2012 objects and properties

The following data sources can be used:

  • FileTables
  • Sequences
  • Columnstore indexes

Columnstore indexes

Additionally, DDL changes on sequences used on tables created in earlier SQL Server versions are captured as well

Besides DDL operations, DML operations affecting FileTables are captured as well

filetables

All captured operations affecting the new SQL Server 2012 objects can be scripted, exported, replayed or undone just as any other operation