I have a client with a mission critical SQL Server serving local network and VPN users that wants offsite database backups. Compressed, the database backup is about 80MB, not huge, but big enough to cause a slow network some problems.
I tried using Azure Storage and completing a demo to backup a very small database was easy to complete however the bandwidth requirements are quite steep so I had to abandon the effort. It worked out to need a minimum of 8 Megabit upload line-speed or else the backups would timeout. This particular client cannot be guaranteed those types of line speeds from their basic business-class internet provider. I really like the way backing up to Azure Storage is integrated with the BACKUP DATABASE statement, but alas it seems like it was not meant for this project.
For small businesses that have a SQL Server instance at a branch office and only a business class DSL or cable internet line, what would be the best offsite backup solution? So far I have looked at Azure Storage as mentioned and even using Microsoft SkyDrive (I know). Carbonite seems like a decent option but I read that even if you have a capable connection they severely throttle their bandwidth. Any guidance on a product or solution?
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato