SQL/MP Version Management Guide

Mixed Version Networks
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
6-12
Version 300 or Newer Utilities and Newer Version
Software
•
BACKUP or RESTORE cannot access an object whose version is newer than the
version of BACKUP or RESTORE being used. For example, these situations result
in a version error:
°
You attempt to use version 300 BACKUP to back up a table whose version is
newer than 300.
°
You attempt to use version 300 RESTORE to restore an index with a version
newer than 300 or attempt to restore a version 300 table that refers to a collation
whose version is newer than 300. (For additional information on version
dependency among objects, see Section 3, Database Versions.)
•
BACKUP or RESTORE cannot access a catalog whose version is newer than the
version of BACKUP or RESTORE being used. For example, these situations result
in a version error:
°
You attempt to use version 300 BACKUP to back up a version 300 table, but the
table is registered in a catalog whose version is newer than 300.
°
You attempt to use version 300 RESTORE to restore a version 300 table and
register it in a catalog whose version is newer than 300. (For a discussion of
how the AUTOCREATECATALOG ON option of RESTORE affects catalog
version, see Section 3, Database Versions.)
•
BACKUP or RESTORE cannot access an SQL program whose version is newer
than the version of BACKUP or RESTORE being used. For example, these
situations result in a version error:
°
You attempt to use version 300 BACKUP to back up an SQL program whose
program catalog version is newer than 300.
°
You attempt to use version 300 RESTORE to restore an SQL program whose
catalog version is newer than 300. (For a discussions of how RESTORE affects
the version of an SQL program, see Section 5, Program Versions.)
To learn how to display the format and catalog versions of an SQL program by using the
RESTORE DETAIL option, see Section 5, Program Versions
.
For the syntax of BACKUP and RESTORE, see the Guardian Disk and Tape Utilities
Reference Manual; for general information on using these utilities, see the NonStop
SQL/MP Installation and Management Guide.