In this article we will see how to do SQL Database backup directly to Azure Cloud Storage. Microsoft Introduced URL Backup from on-premises to Azure Cloud Storage with SQL Server 2012 .
I assume that you have a container set up in Azure Blob Storage Service.
Configuration: Create SQL Server credentials for authentication to the Microsoft Azure Blob storage
CREATE CREDENTIAL AzureStorageCred WITH IDENTITY = 'storage account' ,SECRET = 'HJjm/dfds+MFFmpBLQwiWR+fdsafadfsd+XDAz8uLX/asdasssdfgdsfdsfas==';
Perform the backup
To perform a backup of your database and store it in a blob storage service, get the URL and container name.You can get URL from the Azure Portal as shown in below image
Pass the URL in below format
BACKUP DATABASE [FileTable_upgradeTest] TO URL = N'https://dbproxazurestorage.blob.core.windows.net/dbproxsqlcontainer/FileTable_upgradeTest_backup_2015_10_28_210936.bak' WITH CREDENTIAL = N'AzureStorageCred' , NOFORMAT, NOINIT, NAME = N'FileTable_upgradeTest-Full Database Backup', NOSKIP, NOREWIND, NOUNLOAD, STATS = 10 GO