Restoring a SQL Database In-Place

Updated

On this page

You can restore one or more SQL databases to the same path on the same client where the database was backed up.

Procedure

  1. Access the databases that you want to restore using one of the following methods:

    1. To restore a single database to a point-in-time, complete the following steps:

      1. From the navigation pane, go to Protect > Databases, and then click the Databases tab.

        The Databases page appears.

      2. Select the database that you want to restore.

        The database page appears.

      3. Under Recovery points, select a date that contains a backup.

        Dates that are highlighted indicate that a backup exists for that day.

        Tip: You can also select a specific time of the backup for a point-in-time restore.

      1. Click the date, and then click Restore.

    2. To restore one or more databases in an instance, complete the following steps:

      1. From the navigation pane, go to Protect > Databases.

        The Instances page appears.

      2. In the row for the instance, click the action button , and then click Restore.

        The Select database to restore page appears.

    3. Select the databases that you want to restore, and then click Restore.

      The Restore options dialog box appears.

  2. Click Submit.