1a. Import in Lightroom from CF (5D2, 1D2) or SD (X100) to a 500GB G-Drive Mini FW800 external drive
1b. Lightroom catalog lives on 240GB SSD in my i7 MacBook Pro (which gives me a consistent 4-500 MB/s...awesome!)
1c. Memory card is not formatted until I have backed up the 500GB external drive
2. Catalog is automatically backed up by Time Machine every hour.
3. 500GB external is backed up automatically at 9:30AM every day to a 1TB LaCie drive in my office.
4. 1TB LaCie is backed up weekly to a second 1TB LaCie drive, also in my office.**
5. At the end of the calendar year, I archive the previous year's photos onto 2 external USB 2.0 drives, one of which lives at my parents, one of which lives in my office.
6. Also at the end of the year I format the FW800 drive to give me a new 500GB of space for the coming year.
7. Exported JPGs go to the FW800 drive and/or to Photoshelter.
This system has some big benefits for me. My LR catalog is always backed up, so my edits are never more than an hour old. The photos themselves are backed up daily, and always exist in at least two places.
The weakness of my system is noted by the ** above, and that is that my secondary backup lives in the same place as my primary backup. Thus, I'm not protected against theft or fire/flood/etc. Theft I'm not too worried about, since I work in a very secure environment (think triple card access + key entry + 24h security), but fire could be an issue, I suppose.
No RAID setups involved; I get the speed of an HD-based RAID 0 with my SSD for my LR catalog, anyway, and I have no need for the redundancy of RAID-1.