Support for Backup to Azure Blob Storage
Starting with SQL Server 2012 SP1 CU2 users have had the ability to backup databases to a URL. This functionality is backwards compatible (through the GUI, but not T-SQL) to 2008. However, prior to SQL 2014, there was no way to encrypt backups without using transparent data encryption. What would be a really nice to have is the ability to backup a database to Azure blob storage. This would likely need to be a local backup that was moved to Azure, but it could use the native encryption in SQL Backup.
I would really like to see a way to either backup to Azure as a Blob, or duplicate a database directly to Azure SQL services as a form of backup, as well.
As an option, currently, for those that may want to take advantage of sending a backup to Azure as a Blob file, we currently use a product called Backup4All which has a number of cloud storage options, including Azure, included. We use it for our file server backups at the moment, and easily could be incorporated as a way to throw your data files up on Azure as well, once the SQL backup has completed.
It does mean a 2 part solution, as opposed to 1, but would make it possible.
At the moment, we’re holding off on adding any further cloud storage options to SQL Backup Pro. There are various ways in which backup to Azure (or other cloud storage service) can be achieved fairly easily outside of SQL Backup, for eg, both Azure and AWS provide command-line tools that can help here (ref. https://azure.microsoft.com/en-gb/documentation/articles/storage-azure-cli/ , http://docs.aws.amazon.com/cli/latest/reference/s3/sync.html ). Obviously we’ll keep our eyes open to customer feedback in this area.
[I've also cleaned out as much of the spam as I can spot.]
SICK OF SEEING THIS "A***y" GARBAGE - politely, "Go troll elsewhere..."
On to more serious matters, can Red Gate give us any feedback on this simple proposition because it has been on the record for over 15 months now...
Joey D'Antoni commented
For clarity that that is encrypt a backup and send it up to Azure.