6 cases when you really need a SQL Server transaction log reader

ApexSQL Log is a SQL Server database transaction log reading tool which can read online transaction logs, detached transaction logs, and transaction log backups – both native and natively compressed.

As a SQL Server transaction log viewer, it’s focused on DML (data) and DDL (structure) operations, and what data or objects were changed by the operations. In addition to showing the logical content of a transaction log file, ApexSQL Log provides more features, like a row history for DML operations, creating Undo/Redo scripts, and exporting the audited information in various formats.

ApexSQL Log is useful in addressing the following requirements:

Audit changes on a database schema or data

In scenarios where no auditing was previously set on a database, or existing auditing cannot provide sufficient information, ApexSQL Log can help. It reads an online, detached, and transaction log backups and provides detailed information about all DDL and DML operations (45 in total) that were executed on the database. The audited information can be shown either in the application main grid or exported to an HTML, XML, SQL, CSV, or SQL Bulk file.

Troubleshoot security issues

If some changes were made on a database and you need to find out who made them, use ApexSQL Log. Along with the other information about each transaction recorded within a transaction log, SQL Server records a username of a user who performed the change.

Repair data that was inadvertently updated or deleted

One of the most common scenarios where ApexSQL Log can help is when data was inadvertently updated or deleted and it needs to be reverted to its original value. To do that, use the Create undo script option. The undo script can be created either for all transactions or just the ones you select, depending on what you need to be rolled back.

Undo data that was inserted

In case wrong data was inserted into a database, it can be a problem to determine what was inserted and safely delete only the inserted data. Similarly to inadvertently updated or deleted data, use the Create undo script option which creates script that will delete wrongly inserted data when executed against the database.

Repair a database schema was inadvertently changed

If database objects were altered or dropped accidently and you need to recover them, ApexSQL Log can provide an undo script that will re-create the dropped objects or revert the changes.

Restore a database to a point in time

There are various scenarios when restoring a database to a point in time can be required. For example, a failed large batch update process, storage media failure, providing a database state from a certain time frame for auditing or developing purposes, etc. Using the Time range and other filters in ApexSQL Log, you can precisely specify the transactions you want to apply to the database.

April 28, 2015