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

Using Restore Wizard

Step 1. Specify the Restore Point

Select the state to which the database should be restored:

  • Restore to the current restore point option instructs Veeam Explorer to recover the database to the moment when current restore point of SQL server VM was created. With this option selected, you will proceed to step 3.
  • Restore to a point in time option instructs Veeam Explorer to recover the database to the state as of the specified moment.

Use the slider to specify the point in time to which you want the database to be restored. Database will be recovered to the closest VM restore point before the moment you specify on the timeline, and then transaction log replay will bring the database to the necessary state.

The timeline includes the following timestamps (relatively to the current SQL server restore point):

  • Beginning – refers to the previous restore point of SQL server VM which contains selected database backup
  • End – refers to the next restore point which contains selected database backup
  • Finally, you can select the Perform restore to the specific transaction check box, which enables you to review major database transactions around the selected time, and restore the database to the moment in time right before the unwanted change occurred.
    With this check box selected, you will proceed to the Step 2. Having this check box cleared, you will proceed to the Step 3.

Using Restore Wizard 

Using Restore Wizard Note:

Consider the following:

  • If the previous restore point (a server backup) was not found, or the database backup does not exist in it, then the Beginning timestamp will refer to the current restore point.
  • If the next restore point (a server backup) and the corresponding transaction log backup were not found, or if the database backup does not exist in the server backup, then the End timpestamp will refer to the current restore point.
  • If the next restore point (a server backup) was not found, but the transaction log backup exists for the preceding period, then the End timestamp will refer to the latest log backup time.

Step 2. Fine-tune the Restore Point

In this step, you will get a list of database operations logged during the time period you have specified.

Using Restore Wizard 

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.

Using Restore Wizard Note:

For the full list of operations for which this process is supported, refer to the SQL Server Database Operation Selection section.

Step 3. Specify Target SQL Server Connection Parameters

On this step, specify settings for the target server where the database should be restored:

Using Restore Wizard 

Using Restore Wizard Important!

Please, consider the following important information:

  • To be able to copy transaction logs to the target server, the account you specify for the server connection (that is, credentials to connect to the Windows server) should be granted sufficient permissions to access the administrative share on that machine (e.g., \\myserver\C$) - Read and Write are minimal required, Full Control is recommended. See the Permissions section for information.
  • If a database with the specified name already exists on a target SQL server instance, then the restore process will remove it and replace with the database from the backup. Thus, when you click Next, a message will be displayed, asking you to confirm the deletion.

Step 4. Specify AlwaysON Restore Options

If the specified target SQL server supports AlwaysOn Availability Groups, then you will be offered to click Next and specify AlwaysOn restore options. Otherwise, proceed to Step 5.

  • If you plan to use AlwaysOn capability for the database, select the Add the database to the following group check box, then select the necessary availability group from the list. Database will be restored to the primary server (shown in the list of nodes) and replicated to the secondary node(s).
  • If you do not plan to use AlwaysOn capability when restoring the database, clear the Add the database to the following group check box.

Step 5. Specify Files Location

Finally, specify the location to which database and log files will be restored:

Using Restore Wizard 

Default path depends on the SQL server. For example, for SQL server 2008 R2 it will be: %Program Files%\Microsoft SQL Server\MSSQL10_50.<instance_name>. You can click Browse to specify the path you need.

Using Restore Wizard Note:

Default path on a target Windows server may be different.

Finally, click Restore and wait for the process to complete. Veeam Explorer will notify you of the operation results.

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