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:

  1. In the navigation pane, select a database.

You can select the root instance node to restore all the available databases at once.

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

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

Restoring Latest State

Page updated 12/1/2023

Page content applies to build