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

Scenario 2: Restore with Custom Settings

Alternatively, you can carry out the restore procedure with custom settings, specifying the restore point and destination location you need. Do the following:

  1. If necessary, use the link to Pick another restore point.
  2. For database backed up with transaction log backup turned on, you can also select the necessary point in time using the timeline.

Scenario 2: Restore with Custom Settings Note:

For more information on transaction log backup, refer to the Veeam Backup & Replication User Guide.

The timeline includes the following timestamps (relatively to currently selected 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
  • If previous restore point (server backup) was not found, or database backup does not exist in it, then Beginning will refer to current restore point.
  • If next restore point (server backup) and corresponding transaction log backup were not found, or if database backup does not exist in server backup, then End will refer to current restore point.
  • If next restore point (server backup) was not found, but transaction log backup exists for the preceding period, then End will refer to the latest log backup time.
  1. To specify target SQL server database, click the Destination link. Specify the location where you want the database items to be restored: enter sql_server_name\instance_name and database_name.

Scenario 2: Restore with Custom Settings 

User credentials for carrying out the restore procedure via Enterprise Manager will be picked as follows:

  • Firstly, Veeam will try to use the account of the backup job that contains SQL server VM, or the account which is currently logged in.
  • If this account does not have sufficient rights to perform the restore procedure (for example, in case of imported backup), user will be prompted to supply the necessary credentials.

Specified account’s role in the Enterprise Manager should allow that user to restore SQL databases. See the Providing Access Rights section for details.

Scenario 2: Restore with Custom Settings Note:

If you are restoring a database from an AlwaysOn Availability Group to some different location (for example, to another server from Availability Group), consider that the database will be restored but will not be added to any Availability Group.

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

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