Re: Backup and Recovery speed

> From ilist@rmy.emory.edu Tue Nov 29 10:32 MST 1994 > From: tgerber@slowhand.nmb.com (Tom Gerber) > Subject: Backup and Recovery speed > Date: 29 Nov 1994 16:12:55 GMT > To: informix-list@rmy.emory.edu > X-Informix-List-To: informix-distr@ziggy.cfer.com > X-Informix-List-Id: <news.10033> > > With On-Line 5.0 how long would it take to backup a 1 GB database ? > How long to recover (I know this is dependent upon the number of incremental > backups but there should be some guidelines) ? > > I am working on a data archiving system and am currently in the database design phase and I am trying to figure out my database sizing limits based upon size and recovery requirements. Since I have never used Informix before I would appreciate any guidelines on the speed of backups and recoveries. > > Env. Sun 1000 with 16GB Box Hill disk subsystem. > > Thanks. > > > Tom, We are running a daily level zero archive from cron on a 1.2GB database in about 40 minutes. Our experience has been that to restore from that archive takes about 1 1/2 hours. Of course, if you need to also restore logs it takes much longer. I hope this helps. ENVIRONMENT: Sun 1000 running Solaris 2.3 Online 5.03 Two 7GB RAID Disk Subsystems Respectfully, -----------------------------------------------------------------+------------ _______ _______ _______ | /\\ ____\\ /\\__ __\\ /\\__ __\\ David Buchholz | \\ \\ \\___/ \\/_/\\ \\_/ \\/_/\\ \\_/ Unix System Administrator | Standard \\ \\ \\____ \\ \\ \\ \\_\\ \\__ ConferTech International Inc. | Disclaimers \\ \\______\\ \\ \\_\\ /\\______\\ Westerminster, CO. | Apply \\/______/ \\/_/ \\/______/ daveb@cfer.com/(303)633-3089 | | -----------------------------------------------------------------+------------