In this lab, you learn about leveraging Azure storage with SQL Server. You will learn how to leverage Azure storage for backup to URL and snapshot backup with SQL Server 2017.
- Hosting SQL data files directly in Azure storage.
- Leveraging SQL Server backup to URL to backup directly to Azure Storage.
- Leveraging snapshot backups for sub-second backups and restores.
- A basic understanding of Azure Infrastructure as a service
In this exercise, you will create a storage account for use with the SQL Server Backup to URL feature. You will execute a backup and a restore from Azure Storage. You will then backup and restore a database using Azure Snapshot Backups.