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.

Restore a Single Database to a Point in Time

From the navigation pane, go to Protect > Databases.

The Overview page appears.
On the Databases tab, select the database that you want to restore.

The database page appears.
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.
Click the date, and then click Restore.

The Restore options dialog box appears.
Select In-place.
You can configure a schedule to repeat this restore operation. To create a schedule, do the following:
1. Click Schedule.
  
  The Add schedule dialog box appears.
2. In the Name box, type a name for the schedule.
3. Configure the Frequency and Repeat parameters.
4. To specify exceptions to the schedule, click Exceptions.
  
  The Exceptions dialog box appears.
5. Configure the exception parameters:
  - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.
  - Click Save when you have finished configuring the exception parameters.
6. To save the schedule and return to the restore dialog box, click Schedule.
Click Submit.

From the navigation pane, go to Protect > Databases.

The Overview page appears.
On the Instances tab, in the row for the instance that has databases that you want to restore, click the action button , and then click Restore.

The Backup content page appears.
Select the databases that you want to restore, and then click Restore.

The Restore options dialog box appears.
Select In-place.
You can configure a schedule to repeat this restore operation. To create a schedule, do the following:
1. Click Schedule.
  
  The Add schedule dialog box appears.
2. In the Name box, type a name for the schedule.
3. Configure the Frequency and Repeat parameters.
4. To specify exceptions to the schedule, click Exceptions.
  
  The Exceptions dialog box appears.
5. Configure the exception parameters:
  - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.
  - Click Save when you have finished configuring the exception parameters.
6. To save the schedule and return to the restore dialog box, click Schedule.
Click Submit.