Backup SQL Database to the Azure Blob

Kailash Chandra Behera | Saturday, June 13, 2020

Introduction

In my previous two blogs, we demonstrated how to backup SQL database and how to backup SQL database with encryption. In this blog, we will demonstrate how to back up SQL database to Azure blog.

Getting Started

The demonstration below performs a full database backup of the SQL Database to the Azure Blob storage service. Let's say you already have a storage account with a blob container.

You want to backup your database named TestDB, this demonstration creates a shared access signature for you and fails of the container has an existing shared access signature.

Steps to Backup SQL Database to the Azure Blob

  1. Open SQL Server Management Studio and connect to your SQL instance.

  2. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree.

  3. Expand Databases, right-click TestDB, point to Tasks, and then click Back Up....

  4. On the General page in the Destination section select URL from the Back up to: drop-down list.
  5. Click Add and the Select Backup Destination dialog box will open.

  6. If you have previously registered the Azure storage container that you wish to use with SQL Server Management Studio, select it. Otherwise, click New container to register a new container.

  7. In the Connect to a Microsoft Subscription dialog box, sign in to your account.

  8. In the Select Storage Account drop-down text box, select your storage account.

  9. In the Shared Access Policy Expiration drop-down calendar box, select an expiration date for the shared access policy that you create in this example.

  10. Click Create Credential to generate a shared access signature and credential in SQL Server Management Studio.

  11. Click OK close the Connect to a Microsoft Subscription dialog box.

  12. In the Backup File text box, modify the name of the backup file, note that this is optional.

  13. Click OK to close the Select a backup destination dialog box.

  14. Click OK to initiate the backup.

  15. When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.

Related Articles

  1. Backup SQL Database Using SSMS
  2. Enable SQL Remote Connection
  3. Encrypt data across communication channels
  4. Recovery Database From Warm-Standy Mode
  5. List Out Store Procedures That Executes Frequently
  6. Create SQL Job in SQL Server 2017“

Summary

Here in this blog 'Backup SQL Database to the Azure Blob', we demonstrated how to backup your SQL Database to Azure Blog storage. I hope you have enjoyed it.

Thanks