In this lab, we’ll learn about the enhancements made to the database backup and restore feature in SQL Server 2014. In the first exercise, we will learn about taking backup to Azure Storage and restore from the database backup on Azure Storage. In the second exercise, we will learn about encrypting backup files to add one extra layer of security. In the third exercise, we will learn SQL Server managed or smart backup solution.
Exercise 1: SQL Server Backup to URL & Restore from URL
Exercise 2: SQL Server Backup Encryption
Exercise 3: SQL Server Managed Backups to Azure Storage