Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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

 

Applies To: SQL Server 2016 Preview

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

SQL Server integration support for the Windows 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 Windows Azure.

This tutorial shows you how to work with SQL Server Data Files in Windows 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 Windows Azure storage account.

Lesson 3: Database backup to URL

In this lesson, you backup an on-premises database to Windows 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).

Community Additions

ADD
Show:
© 2015 Microsoft