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

Restoring Multiple Databases

You can use Veeam Explorer to restore multiple databases at once: these can be all databases hosted by the certain SQL Server, or all databases of the certain SQL Server instance. You can restore the databases to the current restore point or to the state as of the selected point in time. Restore to the state prior to selected transaction is not available for that scenario.

To restore multiple databases, first check the following:

  1. You have a successful SQL Server VM backup with the application-aware image processing enabled.
  1. You have selected an appropriate restore point of SQL Server VM. See the Recovering Database File from VM Backup section.

Also, decide where you want to restore your databases. To restore to the original server or instance, use 1-Click Restore.

To restore to another server or instance:

  1. Select the required server or instance in the navigation tree on the left, then click Restore Databases > Restore to another server....from the ribbon menu or from the shortcut menu.

Restoring Multiple Databases 

  1. Proceed to the Step 1. Specify Restore Point step of the restore wizard.

Restoring Multiple Databases Note:

  • By default, database files will be restored to the original paths, for example, for SQL Server 2008 R2 it will be:
    %Program Files%\Microsoft SQL Server\MSSQL10_50.<instance_name>.
  • Default path on target Windows server may be different.

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

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide