This scenario allows you to recover your database to the specific point in time (which may differ from current SQL Server restore point). Database will be recovered to the closest VM restore point before the moment you specify, and then transaction log replay will be performed on the target server to bring the database to the necessary state. So, to implement this scenario, check the following:
- SQL Server transaction logging is enabled - database recovery model must be set to Full or Bulk-logged.
- Transaction log handling in the SQL Server VM backup job settings had been configured to keep log backups: the Backup logs option should be selected.
- You have SQL Server application-aware backup created successfully.
Restore to the Original Server
To restore a database to the certain point in time, do the following:
- In Veeam Explorer main window, select the required database in the navigation tree on the left.
- Select Restore Database > Restore point-in-time state to <server_name>\<instance_name>... on the toolbar, or use the same database's shortcut menu command and perform 1-Click Restore.
Restore to Another Server
To restore a database as of the certain point-in-time state, do the following:
- In the navigation pane, select a database you want to restore.
- On the ribbon menu, click Restore Database > Restore to another server. You can also use the corresponding context menu command.
- Select Restore to a point in time and use the slider control to specify the state you need.
- Proceed to Step 3. Specify Target SQL Server Connection Parameters.