Archives of the TeradataForum

Message Posted: Fri, 04 Nov 2005 @ 20:51:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The way we perform our nightly backup is to run a cluster backup. We have a 3-node system with 9 clusters. We use three Ultrium 2 LTO tape drives. Each node is fiber attached to one tape drive. The three data streams run fairly balanced because data skew on the database is minimal. We backup the entire production system, of little under 1 Tb of data, nightly in just a little over two hours.

The drive through-put averages anywhere from 32 Kb/sec to 40 Kb/sec which equates to about 130 to 140 Gb per hour per tape drive (roughly speaking).

I really don't believe that arcmain is the limiting factor as much as other physical parameters. The typical limiting factors are tape drive write speeds, data compression algorithms, bandwidth of connections, etc.

Some questions about your backup process that wasn't evident in you initial posts: Are you running single stream or cluster (multi-stream)? Is your data skewed on your larger tables?

Have you asked your questions with the BAR team via the Global Support center (GSC)? They can often give you information about what your systems through-put should be...they are generally quite knowledgeable about the various hardware systems, especially if they helped set up your backup solution in the first place. You might ask them if the speed of your backup is normal (or average) for your setup...

Michael E. McBride, MSCIS

	<Prev	Next>		<<First	<Prev	Next>	Last>>