This scenario offers the greatest granularity of your database recovery: you can select the undesired operation from the list of database operations (available for the time period you have specified) – for example, user deletion. The database will be restored to the state prior to the transaction containing the specified operation, using log replay on target server.
To implement this scenario, ensure 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 Back up logs option should be selected.
- You have SQL server application-aware backup created successfully.
In Veeam Explorer for Microsoft SQL Server main window, select the required database in the navigation tree on the left, then launch the Restore Wizard:
- To restore database to the original server, click Restore Database > Restore point-in-time to <server_name>\<instance_name> on the toolbar, or use the database's shortcut menu command. Proceed to the Step 1. Specify the Restore Point.
- To restore a database to another server, click Restore Database > Restore to another server on the toolbar, or use the database's shortcut menu command. Proceed to the Step 1. Specify the Restore Point.
If you plan to restore database which is not so highly-transactional, consider that displaying transaction records on the Fine-tuning the Restore Point step of the wizard may take several minutes. This happens because, by default, Veeam Explorer loads the number of transaction logs required to get 200 transactions back and 200 forward from the specified point in time. So, in case of too few transactions within one log file, more transaction logs will be loaded to reach that number. This value can be changed, as follows:
- Go to the %programdata%\Veeam\Backup and Replication\SQLExplorer folder on the machine where Veeam Explorer runs, and locate or create a configuration file named Config.xml in that folder.
- Locate or add the FineTuningMaxLoadedItems configuration parameter to the file content and specify the value you need. For example, for Veeam Explorer to load 50 transactions back and 50 forward from the selected point in time, specify the following:
- Save and close the configuration file.