Azure Basics Part 8 – Backup MS SQL database to Azure Storage

One of most used Azure service is backup. Storage is very cheap in Azure and it gives us option of creating backup very far away from our on-prem environment.

In this post I will cover basics on how to create MS SQL database backup to Azure Storage. Note that for using this option you need at least SQL Server 2012 SP1 CU2. I recommend using latest version of SSMS.

First login to your Azure account and start creating new Storage account. Click ‘New’, select ‘Storage’ and select ‘Storage account’.

1

Now you need to enter deployment information on your Storage account. Enter name, select deployment model, account kind, replication and encryption. Performance should be left at ‘Standard’ as ‘Premium’ is still not supported for SQL backup. Select subscription you want to use (only if you have multiple subscription, if you have only one, this will be filled out automatically), select resource group (create new or use existing one) and finally select location. Click create and wait for few moments (deployment of new storage account is very fast, usually under 20 seconds).

2

Once deployment is done, go to your storage account and create new container.

3

Enter name for container and select access type. As this container should be used for storing database backups, I recommend that you use private or anyone with link to your container could access your data.

4

Creating new container under Storage account takes only few seconds and once done you should see empty container.

5

Now go to SSMS and connect to your local MS SQL Server. Select database that you want to backup and right click on it. Select ‘Task’ and then click on ‘Back up’.

6

In new window change backup destination to ‘URL’ and click on ‘Add’.

7

Click on ‘New container’.

8

Click on ‘Sign in’.

9

Now you need to sign in to your Azure account. Enter your credentials and click to sign in.

10

Select subscription that you used to create new Storage account, select your Storage account and container. Click ‘Create Credentials’ to generate new Shared Access Signature. This is used to Access your Storage account securely. Finally click on ‘OK’

11

Select your Azure storage container and click ‘OK’.

12

Once again, click ‘OK’ and wait for backup to finish.

13

Now go to your Azure account and open Storage account and container you created for this backup. You should see your backup in container.

14

In one of next posts I will cover how to restore database from Azure Storage backup and how to create backup plan to Azure Storage.

Article by Mustafa Toroman

I’m System Engineer at Authority Partners. I love to test and explore new technologies. Have over 20 active MS certificates such as MCSA for Windows Server and SQL Server, MCSE Private Cloud, Data Platform, Business Intelliegence and Server Infrastracture. Lately most interested in BI and Azure solutions. MCT since 2012. From 2016 MVP for Microsoft Azure.

3 Comments


  1. Spectacular internet site. A lot of practical information and facts. I am mailing it to a couple close friends. And naturally, thanks on the efforts!

Leave a Reply

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