SQL/MP Installation and Management Guide

Planning Database Security and Recovery
HP NonStop SQL/MP Installation and Management Guide—523353-004
4-23
Backing Up Collations
This example backs up the table EMPLOYEE, which has one protection view,
EMPLIST, and two shorthand views, EMPSHV1 and EMPSHV2. The example shows
the BACKUP command that backs up both protection and shorthand views:
BACKUP $TAPE,($VOL1.SVOL.EMPLOYEE,$VOL1.SVOL.EMPSHV1,
$VOL2.SVOL.EMPSHV2), LISTALL, OPEN
Backing Up Collations
To back up collations, specify them in the file set list in the BACKUP command, as you
do tables and indexes. Whenever you back up a table, index, or view that uses a
collation, be sure to back up the collation as well, because when the object is restored,
it must use the same collation.
For example, for a table that includes names from different countries, this command
backs up a table, the indexes on a table, and the collations used by the table and the
indexes:
BACKUP $TAPE, ($VOL1.INVENT.SUPPLIER, $VOL2.COLLS.COLLFR,
$VOL3.COLLS.COLLJPN, $VOL4.COLLS.COLLSP,
$VOL5.COLLS.COLLIND, $VOL6.COLLS.COLLKOR),
INDEXES IMPLICIT, LISTALL, OPEN
If you have only a few collations used by many objects, you might want to make a one-
time backup of all the collations and save the backup copies for restoring with
dependent objects. For collations that do not change often, this one-time backup is
easier to manage than repeated backups of the same collations with every dependent
object.
Note. When restoring collations, they must be restored before their dependent objects.