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

Restore and Export Scenarios

Restore

Restore scenarios are implemented as follows:

Export

Export scenarios are implemented as follows:

Using a Staging Server

Scenarios involving a staging SQL Server are described below:

  1. Database files from the SQL Server's backup are mounted to SQL server (staging or target, depending on the required restore scenario).
  2. In particular, staging server is used in Restore to the state before selected transaction scenario - it presents transaction records to users who select the undesired transaction and instruct Veeam to restore database to the state prior to that operation.
  3. Veeam Explorer for Microsoft SQL Server obtains SQL server hierarchy information (instances and databases) and presents it to the user.
  4. A user chooses the database to restore and specifies target location (original or another server), settings required to access that server, as well as the required point in time or undesired transaction.
  1. Database files (including log files, if necessary) are then copied from the repository to the Windows machine hosting the target server, the database is attached to target SQL server, put in the desired state (using log replay, if necessary) and becomes ready for use.

Restore and Export Scenarios 

Restore and Export Scenarios Note:

See System Requirements for more information on the staging SQL Server.

Using a Temporary Folder

Veeam Explorer needs a staging Microsoft SQL Server for several export scenarios: export to selected point in time and export to the state before selected transaction. The staging SQL Server should meet several requirements listed in this document. Refer to the How Veeam Explorer for Microsoft SQL Server Works and the Staging SQL Server sections for details. You can configure a path to the temporary location on the staging SQL Server where the log files will be stored during export scenarios. There can be other scenarios when you need to configure a path to the temporary folder where data should be stored – for example, when restoring a database from the AlwaysOn Availability Group.

To configure a path to the temporary folder, do the following:

  1. Go to the %programdata%\Veeam\Backup and Replication\SQLExplorer folder on the machine where Veeam Explorer runs, and locate or create a new configuration file named Config.xml in that folder.
  2. Locate (or add) the TempFolderPath configuration parameter to the file content and use it to specify the location you need (default is C:\tmp):

<Veeam>
    <SQLExplorer TempFolderPath="C:\New_tmp_folder"/>          
</Veeam>

  1. Save and close the configuration file.
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