Restore Tables from a SQL Clone

You can browse and restore individual tables from a SQL clone.

Note

A table restore operation does not contain Filestream data.

Procedure

From the navigation pane, go to Protect > Databases.

The Overview page appears.
On the Instant clones tab, click the clone that you want to restore individual tables from.

The instant clone page appears.
In the upper-right corner of the page, click Restore tables.

The Backup content page appears.
Select one or more tables that you want to restore, and then click Restore.

The Restore options dialog box appears.
To restore all the child tables of the selected table, select Include all child tables.
To restore all parent tables of the selected table, select Include all parent tables.
In the Database name box, select the destination database where you want to restore the tables.
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. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.
7. To save the schedule and return to the restore dialog box, click Schedule.
Click Submit.