Step 1. Launch Restore Wizard

In this article

    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