If you plan to restore a database using this scenario, consider that you will need an application-consistent image-level backup (or replica) of your SQL Server VM, successfully created by Veeam backup (or replication) job. Remember the following:
- Any logging and recovery model can be set for this database.
- In the Veeam job settings, the Enable application-aware image processing check box should be selected in Guest Processing options:
- On the General tab of the advanced guest processing settings dialog, the following options should be selected:
- Require successful processing (recommended) – in Applications section
- Process transaction logs with this job (recommended) – in Transaction logs section
- Any transaction log handling option can be selected on the SQL tab.
Refer to the https://helpcenter.veeam.com/backup/explorers/vesql_bu_job_settings.html to learn more.
Also, consider that such a scenario has 2 options:
- Restore to the original location
- Restore to custom location
Restore to Original Location
Use 1-Click Restore if you need to quickly restore a database to the original location (that is, the SQL Server instance that was originally hosting the database). Restore process will be performed with the following settings:
- Database will be restored to the current restore point (that is, to the moment when currently mounted backup or replica of SQL Server VM was created).
- Database will be restored to the original VM (files will be copied to the original location and then attached to the original SQL Server instance).
- By default, Veeam will first use current user credentials and Windows authentication method to connect to target SQL Server. If these credentials are insufficient, then Veeam will try using the account specified for guest OS access in the SQL Server backup job settings. If it does not suit either, you will be prompted to enter the credentials manually.
The account used for connection to SQL Server should have administrative rights on that server.
To launch 1-Click Restore from Veeam Explorer, select the required database in the navigation tree on the left, then select Restore Database > Restore <current_state_date> to <server>\<instance> from the toolbar or from the node’s shortcut menu:
You can also restore multiple databases at once – for that, select the required server or instance in the navigation tree on the left, then:
- If restoring multiple databases of the selected SQL Server, select Restore <current_state> to <server_name> - in this case, all databases will be restored to corresponding instances on that (original) server.
- If restoring multiple databases of the selected instance, select Restore <current_state> to <server_name>\<instance_name> - in this case, all databases will be restored to the specified instance on the original server.
If you are to launch 1-Click Restore in Enterprise Manager:
- Log in to Enterprise Manager with sufficient rights, then on the Items tab click SQL.
- Enter the name of SQL Server hosting the database you need to restore; use the server_name\instance_name format. Alternatively, click the link to pick server from the list of available SQL Server VM backups.
- Select the database you need and click the Restore button.
Restore to Custom Location
To restore database to the state as of in currently selected restore point, but to a server different from the original, follow the steps described in this section of Veeam Explorers document. If using Enterprise Manager, follow the steps described in this section of Veeam Enterprise Manager User Guide.