Re: Logical log backup and Archival of data

Clem Akins writes: -> ->} [...] ->} I would like to hear from people on the net about how they are backing up ->} their logical logs and the doing the archive of the data on one tape ->} device. I am sure there are quite a lot of you out there who have ->} done this. ->} ->} What I am thinking of doing is to back up the logical logs on to the disk ->} first and then back it up on the tape. Is this the best way ? ->} ... -> ->We keep everything on disk, and don't even use the tape drives. We archive ->to disk, compress the archive, and transfer it to disk on a remote node for ->off-site storage. I've done this both ways several times and it is very ->robust. We do the same thing with cpio for file systems (source code, etc). ->Just be *really sure* that you have enough space on the disk to hold the ->entire archive/log, if you don't then you will be in trouble. ;) Careful... While it may be robust, unless you're using onarchive, archiving to disk is NOT supported by Informix. This means if you call Tech Support with an archive or restore problem and you are backing up to an unsupported device, they will not help you. Look before you leap! Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (970) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (970) 491-1205