Share via


Tutorial: Getting Started with SQL Server Backup and Restore to Windows Azure Blob Storage Service

Welcome to the Getting Started with SQL Server Backup and Restore with Windows Azure Blob Storage Service tutorial. This tutorial helps you understand how to write backups to and restore from the Windows Azure Blob storage service.

SQL Server Backup support for the Windows Azure Blob storage service is a SQL Server 2012 SP1 CU2 enhancement. For an overview of the functionality and benefits of using this functionality, see Backup and Restore Enhancements

What You Will Learn

This tutorial shows you how to create a Windows Storage account, a blob container, creating credentials to access the storage account, writing a backup to the blob service, and performing a simple restore. This tutorial is divided into four lessons:

Requirements

To complete this tutorial, you must be familiar with SQL Server backup and restore concepts and T-SQL syntax. To use this tutorial, your system must meet the following requirements:

  • An instance of SQL Server 2012 with SP1 CU2 update, and AdventureWorks2012 database installed.

    The SQL Server instance can be on-premises or in a Windows Azure Virtual Machine.

    You can use a user database in place of AdventureWorks2012, and modify the tsql syntax accordingly.

  • The user account that is used to issue BACKUP or RESTORE commands should be in the db_backup operator database role with Alter any credential permissions.

Additional Reading

Following are some recommended reading to understand the concepts, best practices when using Windows Azure Blob storage service for SQL Server backups.

  1. SQL Server Backup and Restore with Windows Azure Blob Storage Service

  2. Backup and Restore Best Practices with Windows Azure Blob Storage Service

See Also

Other Resources

Backing up the database and log

Creating a full file backup of the primary filegroup

Restoring a database and move files