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:
- Launch Veeam Explorer for Microsoft SQL Server, open main menu and click Options.
- Select an SQL Server instance from the list, or click Browse.
- 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.
- Specify account that will be used to access Windows machine where that SQL server runs. You can also use current account or another account.
- Click Apply, then close the dialog.
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:
- In Active Directory Users and Computers, select the necessary staging SQL Server.
- 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.
- After that, restart the staging SQL Server.
- 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.
Contact your Active Directory administrator, if necessary.