Re: Informix OnLine backup alternative ?

ssjen@iphase.com (Shen Shane Jen) writes: >Hi, >Is there any other backup alternative available for Informix OnLine ? >We are running Informix OnLine 5.01 on Sun 490 using raw partition and >having been using the online backup utility happily (if it could let you >backup and restore selected tables ...) from the first day we got it. >The problem is my boss like the idea of doing Informix backup the same >way we do other systems' backup through the Legato Networker backup >system, or something similar so we don't have to change tape every day >and every backup is done the same way (at least from the operator's point >of view). >Is there any backup system out there that will backup the raw disk partition >and also preserve the database's integrity at the same time ? >Although I'm pessimistic about this, but any information is appreciated, >positive or negative. Thanks. >Richard Jen >MIS Sr. Programmer/DBA >Interphase Corp. TEL : (214) 919-9305 >13800 Selac Drive FAX : (214) 919-9200 >Dallas, TX 75234 If you need the database for quick access more than for *lots * of data (like I do) consider the following. Every day before backuptime you run (by cron) a dbexport on all the databases and compress the resulting data. After backup you can delete the compressed data. This solution implies enough free space on your disks. I am sure, there is a more elegant solution - but for a quick and dirty approach it certainly worked for me :^) Chris ------------------------------------------------------------------------------- Christoph Maethner voice +49 211 990 77 81 systems engineer fax +49 211 990 75 70 Rank Xerox Germany e-mail chmae@guug.de mae.sbd@rxg:Xerox:com -------------------------------------------------------------------------------