I may have missed something, but do all the Full backups have to be on the same day?
You mention fortnightly Full backups. You can pile up a couple of smaller servers on Day 1 (perhaps servers 1, 2, 4, 11, 17), for Full backups, and Diff backups for the rest of the servers. Then you have all day to compress and ship all those backups. Day 2, do Full on server 3, Diff on all the rest, during the maintenance window, then compress and ship during regular hours (that shouldn't interfere with anything database-wise). Day 3, Full on server 5, Diff on all the rest. And so on.
The Diff backups should be, per what you're saying here, significantly smaller and faster than the Full backups.
Would something like that work, or did you already try that and I just didn't read it correctly?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon