Solving Errors with Existing BLOB Leases When Using BACKUP TO URL
BACKUP TO URL was introduced as an add-on in Cumulative Update 2 for SQL Server 2012 Service Pack 1 and as a built-in feature for SQL Server 2014. I previously described this in a blog post.
We have been using this in a variety of ways from on-premises systems:
For example, it is an easy way to distribute a backup of a database to a large number of systems. Imagine you have a chain of retail stores that needs product and other reference information updated regularly. You can keep this data in a separate database at the head office, back it up to an Azure Storage account, and have each store download it separately. This has major bandwidth and reliability improvements over other solutions such as having each store maintain a VPN connection to the head office.
2014-07-09