Help Center
Choose product document...
Veeam Backup & Replication 9.5 Update 4
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 an account with the sufficient permissions. For more information, see Providing Access Rights.
  2. Go to the Items tab and click SQL Database.

Restore Procedure 

  1. Enter a name of SQL Server hosting the database you need to restore; use the server_name\instance_name format. Alternatively, click the Pick from List link to select from the list of available SQL Server machine backups.
  2. 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:
  1. Veeam Backup Enterprise Manager will try to use the account of the backup job that contains the SQL Server machine.
  2. 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 provide the necessary credentials.

Restore Procedure Note:

For more information on the account roles in Veeam Backup Enterprise Manager that allow the user to restore SQL databases, see Providing Access Rights.

For more information on the possible restore scenarios, see 1-Click Restore to Original Location and Restore with Custom Settings.

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 Explorers User Guide

Backup and Restore of SQL Server Databases

Veeam Plug-ins for Enterprise Applications

PowerShell Reference

Veeam Explorers PowerShell Reference

RESTful API Reference

Required Permissions

Veeam Availability for Nutanix AHV

Veeam Backup for Microsoft Office 365 Documentation

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation