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.