Backup and Restore 2 Manual

Backup and Restore 2 Overview
Backup and Restore 2 Manual—522696-019
1-7
SQL/MX
Unsupported OSS Objects
You cannot back up or restore device special files (character special files and block
special files) and socket files. These objects are skipped if you attempt to back them
up, either implicitly (by specifying a directory that contains the file) or explicitly (by
specifying the file).
SQL/MX
NonStop SQL/MX is the NonStop relational database management system based on
ANSI SQL-92. An SQL/MX database is a collection of tables containing all data, all
objects associated with the tables, all associated file labels, and metadata. Although
only one SQL/MX database can exist on a node, an SQL/MX database and SQL/MP
database can exist on the same node. SQL/MX includes:

User metadata

The SQL language for retrieval, manipulation, and control of data

A programmatic interface

An SQL conversational interface (MXCI)

A set of utilities
For Backup and Restore 2:

SQL/MX does not support the HP NonStop Storage Management Foundation
(SMF) or virtual disk volumes. Therefore, an attempt to back up or restore a virtual
disk volume is rejected with an error.

To back up or restore SQL/MX objects, you must either be the object owner or the
super ID (255,255). You can back up or restore a catalog using any user ID but
should use a user ID that allows you access to the objects subordinate to the
catalog.

To back up or restore SQL/MX objects, you must either be the object owner or the
super ID (255,255). The one exception is the catalog object.

For more information about SQL/MX recovery and backup strategies, see the
SQL/MX Management Manual.