Help Center
Choose product document...
Veeam Backup Free Edition 9.0
Backup and Restore of SQL Server Databases

Step 2: Prepare Staging SQL Server

To restore or export database to the state as of the current restore point, no extra configuration is needed. However, as described in the How It Works section, to support other scenarios, Veeam Explorer for Microsoft SQL Server needs a staging Microsoft SQL Server. In particular, it is required for the following operations:

  • Restore to the state before selected transaction
  • Export to selected point in time
  • Export to the state before selected transaction

By default, local Microsoft SQL Server deployed with Veeam backup server is used for that purpose. To specify another staging server:

  1. Launch Veeam Explorer for Microsoft SQL Server, open main menu and click Options.
  2. Select an SQL Server instance from the list, or click Browse.
  3. Specify user account that will be used to access this SQL server - this can be current account (the one under which Veeam Explorer is running) or another account.
  4. Specify account that will be used to access Windows machine where that SQL server runs. You can also use current account or another account.
  5. Click Apply, then close the dialog.

Step 2: Prepare Staging SQL Server Important!

  • Remember that your staging system must have the same or later version as the original SQL Server.
  • Make sure the accounts you specify have sufficient permissions to connect to Windows machine and to access SQL server.
  • Consider that specific ports on staging server will be used during restore session, as described in the Check Required Ports section.

Step 2: Prepare Staging SQL Server 

If you plan to add database(s) to Veeam Explorer scope manually, consider the following when setting up the staging SQL Server:

  • If this SQL Server belongs to an untrusted domain, connection will not be possible.
  • If this SQL Server belongs to a trusted domain, then only SQL Server authentication is possible.
  • If this SQL Server belongs to the same domain as the machine where Veeam Explorer runs, then both Windows and SQL Server authentication methods are possible. In this case, if staging SQL Server is running under local account and you plan to use Windows authentication for connection, you will need to configure delegation settings as follows:
  1. In Active Directory Users and Computers, select the necessary staging SQL Server.
  2. Open its properties and go to the Delegation tab. Select Trust this computer for delegation to specified services only and Use any authentication protocol options for the cifs service on the computer where Veeam Explorer runs.
  3. After that, restart the staging SQL Server.
  4. Select the domain user account that you want to use for connection to the staging SQL Server, and in its properties on the Account tab make sure the Account is sensitive and cannot be delegated check box is cleared.

Step 2: Prepare Staging SQL Server Note:

Contact your Active Directory administrator, if necessary.

Veeam Large Logo

User Guide

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Administrator Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation