Re: Backup and Recovery speed
Posted in 1994
> 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 currently run a daily level zero archive from cron on a 1.2GB database in about 40 minutes. Our experience has been that a full restore of that archive takes about 1.5 hours. Hope that helps. Environment: Sun 1000 running Solaris 2.3 Informix Online 5.03 Two 7.5 GB RAID 5 disk subsystems See Ya, -----------------------------------------------------------------+------------ _______ _______ _______ | /\\ ____\\ /\\__ __\\ /\\__ __\\ David Buchholz | \\ \\ \\___/ \\/_/\\ \\_/ \\/_/\\ \\_/ Unix System Administrator | Standard \\ \\ \\____ \\ \\ \\ \\_\\ \\__ ConferTech International Inc. | Disclaimers \\ \\______\\ \\ \\_\\ /\\______\\ Westerminster, CO. | Apply \\/______/ \\/_/ \\/______/ daveb@cfer.com/(303)633-3089 | | -----------------------------------------------------------------+------------