You can browse and restore individual tables from a SQL clone.
Note
A table restore operation does not contain Filestream data.
Procedure
-
From the Command Center 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:
-
Click Schedule.
The Add schedule dialog box appears.
-
In the Name box, type a name for the schedule.
-
Configure the Frequency and Repeat parameters.
-
To specify exceptions to the schedule, click Exceptions.
The Exceptions dialog box appears.
-
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.
-
-
Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.
-
To save the schedule and return to the restore dialog box, click Schedule.
-
-
Click Submit.