Re: Large Database Backups
Interesting! We've taken a look at Spectralogic's tape library and Alexandria. We are impressed with Alexandria but have reservations about being on the bleeding edge with their AIT drives. I'd be interested to hear how well Alexandria works with your hardware. Thanks for you input. B In article <5sds4j$ajf@cssun.mathcs.emory.edu>, settler@dbintellect.com says... > >}>From ilist@rmy.emory.edu Thu Aug 7 13:25:30 1997 >}>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) >}> by hobbes.dbintellect.com (8.8.6/8.8.6) with ESMTP id NAA15911 >}> for <settler@dbintellect.com>; Thu, 7 Aug 1997 13:25:29 -0600 (MDT) >}>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id >NAA04062 for informix-list-out; Thu, 7 Aug 1997 13:35:01 -0400 (EDT) >}>From: Barbara.Grant@rmy.emory.edu >}>Message-Id: <5scgug$73t@drn.zippo.com> >}>Subject: Large Database Backups >}>Date: 7 Aug 1997 06:01:04 -0700 >}>Reply-To: Barbara.Grant@rmy.emory.edu >}>Organization: AT&T Credit >}>Sender: informix-list-owner@rmy.emory.edu >}>To: informix-list@rmy.emory.edu >}>X-Informix-List-Id: <news.41373> >}> >}>We have an Informix 7.10 instance running on an NCR platform. The databases in >}>this instance total over 500 GB. We are trying to find a speedy backup and >}>recovery solution. I'm curious as to how others are managing backups of >}>databases this size. >}> >}>Thanks a lot. >}> >}>Barbara >}>bgrant@capita.com >}> > >Not very well. We have about 300 GB, and we have put together a >script that uses multiple ON-Archive processes to write to the >two IBM MagStar tape drives at our site. It takes about ten >hours to back it all up. We will be purchasing Spectra Logic >Alexandria, and we expect a significant speed-up, since Spectra >Logic "multiplexes" data streams onto a given drive. For >instance, we could have six ON-Archive streams writing to our >two drives, speeding things up significantly. > >------------------------------------------------------------------- >Jeff Craig | dbINTELLECT Technologies, Inc. >Senior Consultant | Golden, CO > | (303) 275-6954 ext. 8008 > | email: settler@dbintellect.com > | fax: (303) 275-2134 >-------------------------------------------------------------------