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

Restore Procedure

To restore a Microsoft SQL Server item, a user should do the following:

  1. Log on to Veeam Backup Enterprise Manager, using the account with the sufficient permissions (see the Providing Access Rights section for details).
  2. Go to the Items tab and click SQL Databases.

Restore Procedure 

  1. Enter the name of SQL Server hosting the database you need to restore; use the server_name\instance_name format. Alternatively, click the link to pick server from the list of available SQL server machine backups.

Restore Procedure Note:

Restore to an SQL cluster from Veeam Enterprise Manager is not supported.

  1. The list of available databases will be displayed. Select the database you need. Consider that 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 machine, 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.

Restore Procedure Note:

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

Now you can perform the restore, following the required scenario.

Related Topics

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