


This will restrict access to all users and accounts which could be able to provide the required information to successfully authenticate in your Azure account.

First of all, when you create a container for Azure Blob storage you should set the access to that container to private.So, if you have chosen to do everything yourself, then below you will find the necessary steps which you have to make in order to backup to Windows Azure storage service.īefore we jump right into the SQL code, there are some things that should be mentioned and you should be aware of when configuring your Azure storage service and your database. We recommend that you check out the application and at least try our free trial service and see for yourself how much easier and convenient it is afterward to do backups. Just before we get started, I would like to tell you that all of the steps that you would have to make, either through Powershell or T-SQL or SMOs (C#) in order to make your backup to a URL (Windows Azure) or other storage mediums are simplified in an easy and quick process of backing up your databases through a ubiquitous web-application,. This backup operation can be performed either from Powershell, T-SQL, or SMOs (SQL Server Management Objects), but in this article we will present you just the version with T-SQL. In this article, we will present you the main idea behind the SQL Server backup to URL feature which has been available since the 2012 SP1 CU2 version.
