So about the only thing I can think of for large backups is USB Thumb Drive.
One of my clients generates a 3GB ENC file during the backup process. We are backing up imported items (due to NYS regulations).
The 3GB file often doesnt backup to AC offsite backup anymore, I guess because its just too large.
We have standard business class high speed (Road Runner from Time Warner Cable) which is a 5MB Download x 768KB Upload.
There is no option from our cable company to increase the speed without going to fiber at 40x the price.
Amazing Charts suggested just backing up to another USB type hard drive at the office, but I don't know how this protects you in the event of water damage (leaky pipe), lightning, fire, etc. (unless you were to take the USB Drive home).
Honestly my clients don't really know how to backup themselves and take it home anyways.
So the best thing I can come up with is backing up once a week (myself) to a USB Flash Drive, and rotating two flash drives because the doctor would like to take it home with them.
I would be getting an IronKey due to the hardware based encryption and we definitely dont want the ENC file in the wrong hands. *After ten bad passwords the $100 ironkey becomes a paperweight* Good if its in the wrong hands, bad if you forget your password.
Has anyone had any luck with doing something crazy. -- Like Site-to-Site VPN using freefilesync to comparing the deltas on imported items and copying them to a remote computer and for the SQL portion having SQL 2005 Standard clustered with a server sitting across the VPN, or having a script dump SQL and copy it over the VPN and drop it to another server.
Or is the USB Thumb drive just the way to go here???...