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

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.