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-27
Using Backup and Restore 2 for Database Recovery
Using Backup and Restore 2 for Database
Recovery
Use Backup and Restore 2 to back up to tape and restore to disk SQL/MX objects,
OSS program files, and other components, as required to properly recover your
database.
Backup and Restore 2 uses BRCOM, the command-line user interface from which you
enter and manage BACKUP and RESTORE commands for SQL/MX and OSS objects.
For detailed information about the BRCOM command syntax, see the Backup and
Restore 2 Manual.
To back up and restore SQL/MP tables or other SQL/MP objects, you must use the
T9074 BACKUP and RESTORE utilities. For more information, see the SQL/MP
Installation and Management Guide, the SQL/MP Reference Manual, and the Guardian
Disk and Tape Utilities Reference Manual.
This subsection contains general guidelines for using Backup and Restore 2 for
SQL/MX objects, including:
•
Frequency of Backups on page 5-30
•
Backup Objects Hierarchy on page 5-31
•
SQL/MX Objects That Are Backed Up Explicitly on page 5-32
•
SQL/MX Objects That Are Backed Up Implicitly on page 5-33
•
Backing Up and Restoring OSS Program Files and SPJs on page 5-35
•
SQL/MX Objects That Are Not Restored by BRCOM on page 5-34
•
Using the RESTORE SHOWDDL ON Option to Re-Create Objects on page 5-36
Note. The backup recovery method provided through Backup and Restore 2 is different from
the recovery methods provided through the TMF subsystem. The Backup and Restore 2
method is normally used as a secondary recovery scheme. Also, remember that an SQL/MX
object recovered by TMF might not be consistent with the current metadata description of the
object.