Use the with dumpvolume = volume_name option to specify the volume name. dump database and dump transaction write the volume name to the SQL tape label. load database and load transaction check the label. If the wrong volume is loaded, Backup Server generates an error message.
You can specify a volume name for each dump device. You can also specify a volume name in the with clause for all devices. Volume names specified for individual devices take precedence over those specified in the with clause.
Table 28-10 shows the syntax for specifying a volume name.
Backing up a database or log |
Loading a database or log |
|
|---|---|---|
dump {database | tran} database_name
to [compress::[compression_
level::]] stripe_device
[at server_name]
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
load {database | tran} database_name
from [compress::]stripe_
device
[at server_name]
[density = density,
|
|
Volume name for single device |
dumpvolume = volume_name, |
dumpvolume = volume_name, |
file = file_name]
[stripe on [compress::[compression_
level::]] stripe_device
[at server_name]
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
dumpvolume = volume_name,
file = file_name] ...]
[with{
density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
|
file = file_name]
[stripe on [compress::]stripe_
device
[at server_name]
[density = density,
dumpvolume = volume_name,
file = file_name]...]
[with {
density = density,
|
|
Volume name for all devices |
dumpvolume = volume_name, |
dumpvolume = volume_name, |
file = file_name,
[nodismount | dismount],
[nounload | unload],
retaindays = number_days,
[noinit | init],
[notify = {client |operator_console}]
standby_access}]
|
file = file_name,
[nodismount | dismount],
[nounload | unload],
[notify = {client | operator_console}]
|
