Backup On-Premises Database To Azure Cloud Storage

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==';

Azure1

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

Azure2

Pass the URL in below format

https://storageaccountname.blob.core.windows.net/container/filename.bak

Backup Database

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *