Re: Large Database Backups

}>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 -------------------------------------------------------------------