At a minimum, all dump and load commands must include the name of the database being dumped or loaded. Commands that dump or load data (rather than just truncating a transaction log) must also include a dump device.
Table 27-4 shows the syntax for backing up and loading a database or log.
Backing up a database or log |
Loading a database or log |
|
|---|---|---|
Database name Dump device |
dump {database | tran} database_name
|
load {database | tran} database_name
|
to[compress::[compression_ level::]] |
from [compress::] |
|
Dump device |
stripe_device |
stripe_device |
[at server_name]
[density = density,
blocksize = number_bytes,
capacity = number_kilobytes,
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,
dumpvolume = volume_name,
file = file_name,
[nodismount | dismount],
[nounload | unload],
retaindays = number_days,
[noinit | init],
[notify = {client | operator_console}]
standby_access}]
|
[at server_name]
[density = density,
dumpvolume = volume_name
file = file_name]
[stripe on
[compress::]stripe_device
[at server_name]
[density = density,
dumpvolume = volume_name,
file = file_name] ...]
[with{
density = density,
dumpvolume = volume_name,
file = file_name,
[nodismount | dismount],
[nounload | unload],
[notify = {client | operator_console}]}]
|
