This scenario allows you to recover selected SQL database up to the moment when the current (i.e. currently mounted to the Veeam backup server) restore point — backup or replica — was created for the SQL server VM. To implement this scenario, you do not need to configure log backup or recovery settings; check only the following:
- You have a successful SQL server VM backup with application-aware image processing enabled.
- When recovering database file from the VM backup or replica, you have selected the necessary restore point of SQL server VM (see the Obtaining Database File from VM Backup section above).
Choose where you want to restore your database:
- To restore to the original server, use 1-Click Restore.
- To restore to another server, select the required database in the navigation tree on the left, then click Restore Database > Restore to another server... on the toolbar, or use the corresponding database's shortcut menu command and proceed to the Step 1. Specify the Restore Point step of the restore wizard.