Restoring a SQL Database In-Place

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, click Solutions > Databases > SQL Server, and then click the Databases tab.

         The Databases page appears.

      2. Select the database that you want to restore.

         The database details page appears.

         Under Backup history, select a date that contains a backup.

         Dates with dots indicate that a backup exists for that day.

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

      3. Click the dots icon next to the time, and then select Restore.

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

      1. From the navigation pane, click Solutions > Databases > SQL Server.

         The Instances page appears.

      2. Right-click the instance that you want to restore, and then click Restore.

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

      The Restore options dialog box appears.

2. Click Submit.