Introduction
Imagine that you work for a retail organization that recently moved its enterprise resource planning (ERP) database to Azure SQL Database. This database holds critical operational data that you must protect from data loss or corruption. You need to set up backup and retention policies to ensure the organization can recover from disasters. You must be familiar with the steps and options to recover, in case the need arises.
Azure SQL Database automatically creates database backups. To ensure that you meet the requirements of the business, it's important to understand the specifics of each service tier, point-in-time restore history, long-term retention, and other fundamentals of database backup retention.
In this module, you'll see how to configure backup and long-term data retention policies. You'll also learn about database restore procedures.
Learning objectives
At the end of this module, you'll be able to:
- Configure backup and retention of a single Azure SQL database.
- Restore a single Azure SQL database.
Prerequisites
- Basic knowledge of the Azure SQL Database service
- Basic knowledge of Azure PowerShell