Lets' dive a bit deeper.
If I backup to external drive X, what happens if drive X fails - where is the protection for that?
You'd need another disk, and set it as a backup as well. Or use an Off Site source via an ISP connection (provides protection from Act of God issues at the system's location, as well as theft of actual equipment).
You can also create 2x mirrors that are independent of one another in the RAID setup. Then use backup software to perform the automated backups from A to B on whatever schedule you deem fit to fulfill your needs.
Simply put, you can use a RAID to backup another RAID. But there is no connection in the RAID software or on the card if it's a hardware implementation. Each array needs to be separated in the sense of direct connections to prevent previously discussed issues from happening. Backup software isn't direct, it's indirect and only occurs when the scheduled time is reached.
Next - I'm currently looking at purchasing a Proavio 8 bay edit box SAS/SATA combo. My understanding is that with port multipliers all drives share the 3 Gb/s bandwidth. With a number of the high density 7200 rpm drives now reaching 300Mb/s (at least on the outer tracks) one could easily exceed 3 Gb/s. Clearly though, either mini SAS or a port multiplier will be necessary - no way 8 cables are headed into the Mac Pro. What is the computer bandwidth if m host controller goes into a 4x slot under SATA 2.0?
EB8-PM /= EB8-MS.
The first uses a Port Multiplier chip, the second is direct connections via an SFF-8088 connector (external Mini SAS). The latter unit can be used with either a RAID card, or non-RAID Host Bus Adapter (they do exist). Cables are clean, but the performance is generated via a RAID card and using the drives in parallel.
However, I presume you meant the EB8-PM unit, which allows you to connect 1x eSATA port per 4x disks in the enclosure (so to operate all 8bays, you'd need 2x eSATA ports and cables). One card can provide both ports, and very inexpensively as well. PM chips can run up to 5x disks per eSATA port, but you'd need an
EB10-PM to do that (or equivalent from another manufacturer).
What you need to understand with PM chips and throughputs, is that at best (disks are RAID0), each can switch between the disks attached to it to achieve a max of 250MB/s or so (3.0Gb/s spec parts). Double it for 6.0Gb/s parts.
In JBOD, it's only as fast as a single disk. Even if you ran WD RE4's (WD2003FYYS), the avg. throughput is ~109.8MB/s (read and write of a single unit; value obtained from test data available from Tom's Hardware for this drive model). 3.0Gb/s or 6.0Gb/s ports won't make a difference here, as either is more than capable of handling a single mechanical disk. SSD can be another matter however.
As per bandwidth of a 4x lane PCIe slot, it's 4*500MB/s (per lane), = 2GB/s. But you'll never see that in practice with an eSATA card. 1GB/s, maybe, with 10x fast disks in a RAID 0 (based on 100MB/s per disk).