Specifying the volume name

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 12-10 shows the syntax for specifying a volume name.

Table 12-10: Specifying the 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}]