Re: Individual database backup/restore
Posted in 1997
Ken Guenther wrote:
snip......
> The onunload command can be used to back up an individual database
> to tape or disk; the onload command restores the database. The default
> device is the archive tape device specified in the server config file.
>
> The downside to onunload is that no logical logs are backed up, so
> it should be done in quiescent mode, or you risk backing up bad data.
>
> The dbexport/dbimport commands function in a similar way, except they
> use ASCII format, so it takes longer and uses more disk/tape. But
> the ASCII format can be transported to almost any other type of hardware.
>
> Ken Guenther
> --------------------------------------------------------
> kguenthe@netacc.net -- The usual disclaimers apply
> Axiom Corporation, 116 Winton Road N, Rochester, NY 14610-1938
> (716)654-1100
> --------------------------------------------------------
Onunload/load lock the database exclusively for the duration of the
operation, hence logs and integrity are not a problem.
Greg
--
Please remove SPAMCHOKER. to get correct EMail address...thanks.