Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases

Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases

 

Updated: January 7, 2016

Applies To: SQL Server 2016 Preview

Welcome to the Working with SQL Server 2016 in Microsoft Azure Blob Storage service tutorial. This tutorial helps you understand how to use the Microsoft Azure Blob storage service for SQL Server data files and SQL Server backups.

SQL Server integration support for the Microsoft Azure Blob storage service began as a SQL Server 2012 Service Pack 1 CU2 enhancement, and has been enhanced further with SQL Server 2014 and SQL Server 2016. For an overview of the functionality and benefits of using this functionality, see SQL Server Data Files in Microsoft Azure. For a live demo, see Demo of Point in Time Restore.

Download

  • To download SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2), go to Evaluation Center.

  • Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2016 already installed.

This tutorial shows you how to work with SQL Server Data Files in Microsoft Azure Blob storage service in multiple lessons. Each lesson is focused on a specific task and the lessons should be completed in sequence. First, you will learn how to create a new container in Blob storage with a stored access policy and a shared access signature. Then, you will learn how to create a SQL Server credential to integrate SQL Server with Azure blob storage. Next, you will back up a database to Blob storage and restore it to an Azure virtual machine. You will then use SQL Server 2016 file-snapshot transaction log backup to restore to a point in time and to a new database. Finally, the tutorial will demonstrate the use of meta data system stored procedures and functions to help you understand and work with file-snapshot backups.

This article assumes the following:

This tutorial is divided into nine lessons, which you must complete in order: 

Lesson 1: Create a stored access policy and a shared access signature on an Azure container

In this lesson, you create a policy on a new blob container and also generate a shared access signature for use in creating a SQL Server credential.

Lesson 2: Create a SQL Server credential using a shared access signature

In this lesson, you create a credential using a SAS key to store security information used to access the Microsoft Azure storage account.

Lesson 3: Database backup to URL

In this lesson, you backup an on-premises database to Microsoft Azure Blob storage.

Lesson 4: Restore database to virtual machine from URL

In this lesson, you restore a database to an Azure virtual machine from Windows Azure Blob storage.

Lesson 5: Backup database using file-snapshot backup

In this lesson, you backup a database using file-snapshot backup and view-file snapshot metadata.

Lesson 6: Generate activity and backup log using file-snapshot backup

In this lesson, you generate activity in the database and perform several log backups using file-snapshot backup, and view file-snapshot metadata.

Lesson 7: Restore a database to a point in time

In this lesson, you restore a database to a point in time using two file-snapshot log backups.

Lesson 8. Restore as new database from log backup

In this lesson, you restore from a file-snapshot log backup to a new database on a different virtual machine.

Lesson 9: Manage backup sets and file-snapshot backups

In this lesson, you delete unneeded backup sets and learn how to delete orphaned file snapshot backups (when necessary).

What information are you looking for, and did you find it? We’re listening to your feedback to improve the content. Please submit your comments to sqlfeedback@microsoft.com

Community Additions

ADD
Show:
© 2016 Microsoft