Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-61
SQL/MX Restore Examples

Restoring a Delimited SQL/MX Schema on page 7-67

Restoring SQL/MX Tables on page 7-67

Restoring a Delimited SQL/MX Table on page 7-68

Restoring SQL/MX Table Partitions on page 7-69

Restoring a Delimited SQL/MX Table Partition on page 7-70

Restoring SQL/MX Indexes on page 7-70

Restoring SQL/MX Indexes Separately on page 7-71

Restoring SQL/MX Index Partitions on page 7-72

Restoring an SQL/MX Object to a Different Target on page 7-72

Restoring a Delimited SQL/MX Object to a Different Target on page 7-75

Restoring SQL/MX Objects With Filtering on page 7-75
For these SQL/MX examples, assume the database structure in Table 7-6 on
page 7-50.
Table 7-7. Database Structure on Tape (page1of2)
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1 Catalog
-sch1 Subordinate schema of cat1
-tab1 Subordinate table of sch1
(created on 30 SEP 2002)
-tpart1 Subordinate table partition of
tab1 (last modified on 31 JUL
2004)
-ind1 Subordinate index of tab1
-ipart1 Subordinate index partition of
the index for tab1
-sch2 Subordinate schema of cat1
-tab2 Subordinate table of sch2
(created on 31 JAN 2003)
-tpart1 Subordinate table partition of
tab2
-tpart2 Subordinate table partition of
tab2 (last modified on 31 AUG
2002)
-tpart5 Subordinate table partition of
tab2