SQL/MP Installation and Management Guide

Planning Database Security and Recovery
HP NonStop SQL/MP Installation and Management Guide—523353-004
4-20
Periodic Full Backups
You might not need to back up subvolumes that the SIT SYSGEN tape can recover or
the audit trails dumped to tape by TMF procedures. This example performs a full
backup on all files except $SYSTEM.SYSTEM.*, $SYSTEM.SYSnn.*, and
$AUDIT.TRAILS.*:
BACKUP $TAPE, *.*.* EXCLUDE ($SYSTEM.SYSTEM.*, $SYSTEM.SYSnn.*,
$AUDIT.TRAILS.*), AUDITED, OPEN, LISTALL
For daily backups, you can also perform volume-mode backups, as explained under
Using Volume-Mode or File-Mode Backup on page 4-24.
Periodic Full Backups
A full backup performed periodically might be adequate for protecting your database.
The time between periodic backups should not exceed the maximum amount of work
that would be acceptable to lose or redo if a catastrophic failure occurred.
This command performs a full backup on all files and includes the catalog tables:
BACKUP $TAPE, *.*.* , AUDITED, SQLCATALOGS ON, OPEN, LISTALL
Daily Timestamp Backups
For large databases, a full backup can be inefficient. For some applications, the
amount of change to database files is uneven; some files might change frequently,
while other files seldom change from day to day.
BACKUP provides a mechanism to perform a partial backup automatically on only
those files that have changed since the last backup date. You can use the features of a
qualified file set list to isolate certain objects, such as files with a specified user ID, files
created or modified within a certain timestamp expression, or files with a certain file
code. By using the WHERE clause of the qualified file set list, you can back up only
SQL files that have been modified from a certain date. The PARTIAL parameter in the
BACKUP command set is valid only for Enscribe files.
If you perform partial backups, you must perform a full backup periodically to ensure
that all files have been saved.
This example uses a qualified file set list to restrict the backup to files that were
modified since the date of the last full backup:
BACKUP $TAPE, (*.*.* WHERE MODTIME AFTER JAN 10 1989),
LISTALL, OPEN, AUDITED
Using the FROM CATALOG Option for SQL Objects
The qualified file set list includes a parameter that can specify objects registered in
specific catalogs. The FROM CATALOG option of a qualified file set list specifies that
only SQL objects registered in the specified catalog are part of the file set list. No
Enscribe files except SQL program files are processed by the FROM CATALOG
option. The objects affected are programs, tables, indexes, views, collations, and