compress= to
compress your dump files to a local file.
at server_name to
specify the remote Backup Server
density, blocksize,
and capacity to specify tape storage characteristics
dumpvolume to specify the volume
name of the ANSI tape label
file = file_name to
specify the name of the file to dump to or load from
stripe on stripe_device to
specify additional dump devices
dismount, unload, init,
and retaindays to specify tape handling
notify to specify whether Backup
Server messages are sent to the client that initiated
the dump or load, or to the operator_console
When a user database is dumped, its database options
are not dumped because they are stored in the sysdatabases table
of the master databases. This is not a problem
if you load a previously dumped database onto itself because rows
in sysdatabases describing this database still
exist in master. However, if you drop the database
before you perform the load database, or if you load the database
dump on a new server, these database options are not restored. To
restore the image of a user database, you must also re-create the
database options.
Table 12-1: Syntax for routine dumps and log
dumps after device failure
Information provided
|
Routine database or log
dump
|
Log dump after data segment
device failure
|
|---|
Command
|
dump {database | transaction}
|
dump tran[saction]
|
Database name
|
database_name
|
database_name
|
Compression to a local file (supported for
backward compatibility)
|
to
[compress::[compression_level::]]
|
to
[compress::[compression_level::]]
|
Dump device
|
stripe_device
|
stripe_device
|
Remote Backup Server
|
[at backup_server_name]
|
[at backup_server_name]
|
Tape device characteristics
|
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
Volume name for single device
|
dumpvolume = volume_name
|
dumpvolume = volume_name
|
File name for single device
|
file = file_name]
|
file = file_name]
|
Characteristics of additional devices (up
to 31 devices; one set per device)
|
[stripe
on
[compress::[compression_level::]]
stripe_device
[at backup_server_name]
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
dumpvolume = volume_name
file = file_name]]...
|
[stripe
on
[compress::[compression_level::]]
stripe_device
[at backup_server_name]
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
dumpvolume = volume_name
file = file_name]]...
|
Characteristics of all dump devices
|
[with {
density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
[with {
density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
Compression to a remote server (recommended syntax
for compressed dumps)
|
compression = compress_level
|
compression = compress_level
|
Volume name for all devices
|
dumpvolume = volume_name
|
dumpvolume = volume_name
|
File name for all devices
|
file = file_name,
|
file = file_name,
|
Tape handling options
|
[nodismount | dismount],
[nounload | unload],
retaindays = number_days,
[noinit | init],
|
[nodismount | dismount],
[nounload | unload],
retaindays = number_days,
[noinit | init],
|
Password; not available for dump tran or load
tran
|
passwd = password,
|
|
Option to dump only completed transactions;
not available for dump database
|
standby_access
|
|
Option to not truncate log
|
|
no_truncate
|
Message destination
|
,
notify = {client |
operator_console}}]
|
, notify = {client |
operator_console}}]
|
Table 12-2: Syntax for load commands
Information provided
|
Load database
or apply recent transactions
|
Return header or file information
but do not load backup
|
|---|
Command
|
load {database | transaction}
|
load {database | transaction}
|
Database name
|
database_name
|
database_name
|
Compression to a local file. Supported
for compatibility with older scripts and dumps.1
|
from [compress::]
|
from [compress::]
|
Dump device
|
stripe_device
|
stripe_device
|
Remote Backup Server
|
[at backup_server_name]
|
[at backup_server_name]
|
Tape device characteristics
|
[density = density,
blocksize = number_bytes,
|
[density = density,
blocksize = number_bytes,
|
Volume name
|
dumpvolume = volume_name,
|
dumpvolume = volume_name,
|
File name
|
file = file_name]
|
file = file_name]
|
Characteristics of additional devices
(up to 31 devices; one set per device)
|
[stripe
on
[compress::]stripe_device
[at backup_server_name]
[density = density,
dumpvolume = volume_name,
file = file_name]...
|
[stripe
on
[compress::]stripe_device
[at backup_server_name]
[density = density,
dumpvolume = volume_name,
file = file_name]...
|
Characteristics of all dump devices
|
[with{
density = density,
blocksize = number_bytes,
|
[with{
density = density,
blocksize = number_bytes,
|
Compression to a remote server.
|
compression,
|
compression,
|
Volume name for all devices
|
dumpvolume = volume_name,
|
dumpvolume = volume_name,
|
File name for all devices
|
file = file_name,
|
file = file_name,
|
Tape handling options
|
[nodismount | dismount],
[nounload | unload],
|
[nodismount | dismount],
[nounload | unload],
|
Password name, not available for load
tran
|
passwd = password,
|
passwd = password,
|
Lists dump files
|
|
listonly [= full],
|
Provides header information
|
|
headeronly,
|
Message destination
|
notify = {client |
operator_console}]]
|
notify = {client |
operator_console}
|
Loads log up to a specified time in the log; load
tran only
|
until_time = datetime}]]
|
until_time = datetime}]]
|
The remainder of this chapter provides greater detail about
the information specified in dump and load commands and volume change
messages. Routine dumps and loads are described first, followed
by log dumps after device failure and the special syntax for truncating
logs without making a backup copy.
