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

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-28
Using Backup and Restore 2 for Database Recovery
Table 5-2 describes how SQL/MX and OSS objects are managed by Backup and
Restore 2. For more information, see the Backup and Restore 2 Manual.
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.