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.
Julia Hayward (Redgate) commented
We have recently released SQL Backup 10, which as noted below allows backups to Azure and generic S3 storage.
Julia Hayward (Redgate) commented
We're in the final stages of implementing backing up to both Azure storage and also generic S3 implementations (eg. Minio.io) and it will be released as part of SQL Backup 10 soon. If anyone is interested in taking a beta version (9.3.0) please get in touch with firstname.lastname@example.org.
Doug tucker commented
It's been two years since we've gotten a comment from "SQL Backup (Admin, Red Gate Software)", could we please get an update?
I too may be forced to abandon RG SQL Backup because of its lack of support for Azure as a option under "Copy backup to hosted storage"
This is a HUGE Deficiency. A major sport-wear brand customer requires us to use Azure as a QA host, while using real servers for production, hosted at a leading vendor data center.
We use SQL Backup Pro. We CANNOT use SQL Backup Pro to copy to Azure and restore-latest on demand.
Please reconsider, again, and make it as easy as a network-copy to mapped drive...
Nick Louw commented
I'd simply like to backup directly to Azure hosted Storage as i can with AWS.
Seriously the tool makes life so simple and easy for backups and restores, i would like to keep using it but i am being told to look for another product purely because Azure hosted storage is not supported.
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.