SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—544536-007
5-28
Using Backup and Restore 2 for SQL/MX Database
Recovery
Table 5-2. Backup and Restore of SQL/MX and OSS Objects (page 1 of 3)
SQL/MX or OSS
Object BACKUP Command RESTORE Command
Catalog Explicitly backs up the named
catalog and all subordinate
objects. See Backing Up
Catalogs on page 5-32.
Explicitly restores the named
catalog and all subordinate
objects.
Schema Explicitly backs up the named
schema and all subordinate
objects. Unless specifically
excluded, a schema is
automatically backed up when
its associated catalog is backed
up. See Backing Up Schemas
on page 5-32
Explicitly restores the named
schema and all subordinate
objects. Unless specifically
excluded, a schema is
automatically restored when its
associated catalog is restored.
Table Explicitly backs up the named
table. Unless specifically
excluded, a table is
automatically backed up when
its associated catalog or
schema is backed up. See
Backing Up Tables and
Partitions on page 5-32.
Explicitly restores the named
table. Unless specifically
excluded, a table is automatically
restored when its associated
catalog or schema is restored.
Partition Explicitly backs up the named
partitions of a named table
when you specify the TPART
object type. To back up both
the SQL data in a table partition
and its metadata, also specify
SQLDATA ON. To back up the
DDL information in a table
partition and its metadata,
specify SQLDATA OFF. See
Backing Up Tables and
Partitions on page 5-32.
Explicitly restores the named
partitions of a named table when
you specify the TPART object
type. To restore both the SQL
data in a table partition and its
metadata, also specify SQLDATA
ON. To restore the DDL
information in a table partition and
its metadata, specify SQLDATA
OFF.
Constraints Unless you specify the
CONSTRAINTS EXCLUDED
option, all SQL/MX constraints
are automatically backed up
when you back up their catalog,
schema, or table. See
Constraints
on page 5-33.
All constraints except
REFERENTIAL INTEGRITY can
be restored with Backup and
Restore 2. To restore a
REFERENTIAL INTEGRITY
constraint, run the OBEY
command file for the constraint
generated by the RESTORE
SHOWDDL ON command. See
Using the RESTORE SHOWDDL
ON Option to Re-Create Objects
on page 5-36.