In this lab, you learn about leveraging Azure storage with SQL Server. We will cover hosting data files directly from Azure Storage, backup to URL and snapshot backups.
- 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.
In the next exercise, you will use File-Snapshots to backup a SQL Server database. You will then restore a database to a previous point in time using File-Snapshot Backups.