Thursday, November 21, 2024
HomeProductsSQL Server ToolsPerforming audit changes and rollback transactions is now simpler than ever

Performing audit changes and rollback transactions is now simpler than ever

There is an old joke that goes something like this: “There are two types of system administrators – those who don’t back up their data yet, and those who already do.”
But no matter how much is written about backing up, we still deal with the loss of information, worktime, and money on a daily basis. Backups are performed periodically, but there is still a possibility of data being unintentionally deleted by someone – you will need to restore this data even though backups are available. Naturally, you would want to trace the source of this data loss and get some additional information about it.

This can be achieved with the help of our new special tool that allows you to look through audit changes and perform rollback transactions – dbForge Transaction Log for SQL Server

Let’s look closer at Transaction Log’s features and capabilities:

  • Work with SQL Server 2012, 2014, 2016, 2017, 2019

Supported Versions of SQL Server

  • Read .mdf, .ndf, and .ldf files and retrieve DML operations INSERT, UPDATE, and DELETE

Retrieve DML Operations

  • Filter the data in transaction logs by query types (INSERT, UPDATE, DELETE) or by date and time

Filter by Query Types

  • Work with .tlp project files to save and quickly access all settings and the general state of your recent work sessions

.tlp Project Files

  • Create Undo/Redo scripts for all operations that satisfy the filtering conditions applied to the transaction log data

Create Undo/Redo Scripts

  • Search through the contents of the grid for specific operations and occurrences of the search phrase

Search Through The Data Grid

  • Get additional information about operations by using the Properties grid in the Details tab

Transaction Properties

  • View INSERTs for rows that were deleted

View Inserts for Deleted Tables

  • Output scripts to SQL documents with an ability to execute them

Export Scripts to SQL

Learn more about dbForge Transaction Log.

You can download a 30-day trial version of Transaction Log and evaluate its functionality for free.

RELATED ARTICLES

Whitepaper

Social

Topics

Products