Step 1. Launch Restore Wizard

To launch the Restore wizard, do the following:

  1. In the navigation pane, select a database or an instance.

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

  1. On the Database tab, select Restore Database > Restore point-in-time state to <server_name>\<instance_name> or right-click a database and select Restore database > Restore point-in-time state to <server_name>\<instance_name>.

When restoring multiple databases, consider that depending on the database recovery model the following cases are possible:

  • Some databases might be restored as of the different time interval.
  • Some databases cannot be restored if there are no transaction logs available for the specified period.

Restore Point in Time State