Help Center
Choose product document...
Veeam Backup & Replication 9.0
Veeam Backup Explorers User Guide

Restoring a Database to Specific Transaction

This scenario offers the greatest granularity of the database recovery: you can select the undesired operation from the list of database operations (available for the time period you have specified) – for example, user deletion. The database will be restored to the state prior to the transaction containing the specified operation, using log replay on target server.

To implement this scenario, ensure the following:

  1. SQL Server transaction logging is enabled - database recovery model must be set to Full or Bulk-logged.
  2. Transaction log handling in the SQL Server VM backup job settings had been configured to keep log backups - the Backup logs option should be selected.
  1. You have SQL server application-aware backup created successfully.

In Veeam Explorer main window, select the required database in the navigation tree on the left, then launch the Restore Wizard:

  • To restore a database to the original server, click Restore Database > Restore point-in-time to <server_name>\<instance_name> on the toolbar, or use the database's shortcut menu command.
  • To restore a database to another server, click Restore Database > Restore to another server on the toolbar, or use the database's shortcut menu command.

Then follow the steps of the Restore wizard:

  1. On the Specify restore point step, select Restore to a point in time and use the slider to specify the point you need.
  2. Select the Perform restore to the specific transaction checkbox.

Restoring a Database to Specific Transaction Note:

Remember that these options will be available only if Microsoft SQL Server database recovery model had been set to Full or Bulk-logged and transaction log handling in the SQL Server VM backup job settings had been configured to keep log backups (see the Required SQL Server Backup Job Settings section).

Restoring a Database to Specific Transaction 

  1. Next, on the Fine-tune the restore point step, you get a list of database operations logged during the time period you have specified. Select the undesired operation (for example, you can select the row deletion or insertion). The database will be restored to the most recent state preceding the selected operation.

Restoring a Database to Specific Transaction 

Restoring a Database to Specific Transaction Note:

For the full list of operations for which this process is supported, please refer to the Appendix.

  1. Complete the steps of the wizard, as described in Using Restore Wizard.

Veeam Explorer will notify you of the restore operation results, displaying a pop-up message.

Related Topic

Required Microsoft SQL Server Backup Job Settings.

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Administrator Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Direct Restore to Microsoft Azure

Veeam Backup FREE Edition User Guide

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation