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

Restoring Database to the Specific Point in Time

This scenario allows you to recover your database to the specific point in time (which may differ from current SQL Server restore point). Database will be recovered to the closest VM restore point before the moment you specify, and then transaction log replay will be performed on the target server to bring the database to the necessary state. So, to implement this scenario, check 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.

Restore to the Original Server

To restore a database to the certain point in time, do the following:

  1. In Veeam Explorer main window, select the required database in the navigation tree on the left.
  2. Select Restore Database > Restore point-in-time state to <server_name>\<instance_name>... on the toolbar, or use the same database's shortcut menu command and perform 1-Click Restore.

Restoring Database to the Specific Point in Time 

Restore to Another Server

To restore database to the specified point in time to another SQL Server, do the following:

  1. Open Veeam Explorer for Microsoft SQL Server.
  2. Select the required database in the navigation tree on the left.
  1. Select Restore Database > Restore to another server... on the toolbar, or use the same database's shortcut menu command.
  1. After the Restore wizard is launched, select Restore to a point in time option and use the slider to specify the necessary point, as described above. Leave the Perform restore to specific transaction check box cleared.
  1. Proceed to the Step 3. Specify Target SQL Server Connection Parameters step of the Restore Wizard. Go through the remaining steps of the wizard and wait for restore operation to complete.
Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation