Step 3. Specify Restore Point
At the Restore Point step of the wizard, select a restore point and a way that Veeam Plug-In will use to restore data:
- Select a point in time to which you want to restore the database:
- Select Restore to the point in time when the selected backup was taken if you want to restore the database to the point in time when the restore point that you selected at the Source step was created.
- Select Restore to any point in time if you want to restore the database to a specific point in time between the selected restore point and a previous restore point. This option is available if you restore data from a backup that contains Microsoft SQL Server transaction logs.
Use the slider control to choose the point in time you need.
- Select Quick recovery if you want Veeam Plug-In to apply differential or log backup to the existing database. Otherwise, Veeam Plug-In will restore an entire database and then applies differential or log backup to the restored database. The Quick recovery option may be helpful, for example, if you plan to restore to an original location and want to minimize the database downtime.
When using the Quick recovery option, consider the following
- Quick recovery is available if you restore data from a backup file that contains differential or log backup. If the backup file contains differential and log backups, Veeam Plug-In applies differential backup to the existing database. If the backup file contains only log backup, Veeam Plug-In applies only transaction logs to the existing database.
- Quick recovery is available if the target database recovery state is NORECOVERY or STANDBY.