Restoring Latest State
You can restore a Microsoft SQL Server database as of the latest state in your backup file.
The data will be restored in the following manner:
- Database files will be copied to the original location and then mounted to the original Microsoft SQL Server.
- If a database with the same name already exists on a target Microsoft SQL Server, it will be replaced with the database from a backup file.
To restore the latest available state of a Microsoft SQL Server database, do the following:
- In the navigation pane, select a database.
You can select the root instance node to restore all the available databases at once.
- On the Database tab, select Restore Database > Restore latest state to <original_location>.
Alternatively, you can right-click a database and select Restore database > Restore latest state to <original_location>.
The name of the restore option depends on the restore point you select during the application item restore process in the Veeam Backup & Replication console.