This scenario offers the greatest granularity of the 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.
A list of SQL database operations and their display names as presented to user for selection when fine-tuning database restore is provided in the here.
|
This restore scenario can be implemented only using Veeam Explorer for Microsoft SQL Server – Enterprise Manager does not support restore to the state before transaction |
To implement such a scenario, check the following:
- SQL Server transaction logging is enabled - logging and 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 was selected.
- You have SQL Server application-aware backup created successfully.
- All nodes of the same AlwaysOn Availability Group (if applicable) are located in the same time zone.
Then follow the instructions provided in the Restoring a Database to Specific Transaction section of Veeam Explorers document.
|
Under certain circumstances, restore to the state before selected transaction may fail with the “The specified STOPAT time is too early” error when the restore is performed from secondary node of AlwaysOn availability group. As a workaround, perform restore from the primary node. |
Tips
If you plan to restore a 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 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:
<Veeam> |
- Save and close the configuration file.
