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

Step 3. Specify Target SQL Server Connection Parameters

Specify the settings for the target server where the database should be restored and click Next:

  • Enter the SQL server virtual machine name and SQL server instance to which you want to restore the database. Use the server_vm_name\instance format. You can select server\instance from the drop-down list, or use the Browse button. The target SQL server must be of the same or later version as the original server. For example, SQL server 2008 database can be restored to SQL server 2008 or 2012, but cannot be restored to SQL server 2005.
  • Enter the database name (by default, the original name will be used). Consider that a database in mirror mode cannot be used as a target.
  • Specify the account to be used for connection with the target SQL server. You can use the current account (under which you are running Veeam Explorer), or specify another account and enter its password.
  • You can select to Use SQL Server authentication; if this check box is not selected, Windows authentication will be used. Remember that the account used to access target SQL server must be assigned the sysadmin role on that server.

Step 3. Specify Target SQL Server Connection Parameters 

Step 3. Specify Target SQL Server Connection Parameters Important!

Please, consider the following important information:

  • To be able to copy transaction logs to the target server, the account you specify for the server connection (that is, credentials to connect to the Windows server) should be granted sufficient permissions to access the administrative share on that machine (e.g., \\myserver\C$) - Read and Write are minimal required, Full Control is recommended. See the Permissions section for information.
  • If a database with the specified name already exists on a target SQL server instance, then the restore process will remove it and replace with the database from the backup. Thus, when you click Next, a message will be displayed, asking you to confirm the deletion.

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