Re: How to backup 1 terabyte database on a timely manner?

With IDS 7.3 (and 9.2 'soon'), a possible alternative is to use the "External Backup and Restore" feature. There is a white paper on www.emc.com (under the Partners/Informix section) which should be on www.informix.com 'soon'. Doug Greg Moye wrote in message <35EC0B9D.291F@eds.com>... >Onbar, a storage manager (i.e. Legato or Veritas...), and a *bunch* of >big, fast tape drives. > >I recently heard of an SAP system based on Informix that's >>500GB big >being backed up in 90 minutes. For really huge databases its all a >question of enough resources (CPU, memory, system bus, fiber channels >etc) to support the compression and bandwidth required. > >You could probably do a terabyte or more an hour if you throw enough >money at it. It's a question of deciding what you need and balancing it >against what you're willing / able to spend. > >Chao Y. Din wrote: >> >> Does anyone have suggestions on how to back up a one terabyte informix >> database? Two more terabytes will be added to the storage soon. The >> situation will be worse by then. If a level zero full backup requires >> more than 48 hours (during weekend), it will not work. >> >> The major portion of the database is used to store images and hence >> blobspaces are used. Another key requirement is how to restore just one >> image or just a few related images from backup device of some kind. >> >> Chao Y. Din > >-- >Greg Moye >The above are my opinions only.