Re: Individual database backup/restore
> Kevin Page <kpage@osbit.demon.co.uk> writes:
> Does anybody know what the best way is to is the setup Informix so that
> I can individually backup and restore databases on an Online 7.14 UD1
> engine is without restoring the other databases as well.
> I have about 20 or 30 databases and splitting them up into there own
> dbspaces is just not a practical option.
>>>>
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
--------------------------------------------------------