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>.

Note

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.

If you select the most recent available restore point, the option name is displayed as Restore latest state to <original_location>.
If you select any other restore point, the option name is displayed as Restore state of <point_in_time> to <original_location>.