You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
Data protection and business continuity are critical for any production database. Azure SQL provides multiple layers of protection — from automatic backups and point-in-time restore to active geo-replication and auto-failover groups. This lesson covers how to protect your data and ensure availability across regions.
Azure SQL Database and SQL Managed Instance both take automated backups without any configuration:
| Backup Type | Frequency | Purpose |
|---|---|---|
| Full | Weekly | Complete database copy |
| Differential | Every 12–24 hours | Changes since the last full backup |
| Transaction log | Every 5–10 minutes | All committed transactions |
When you create a database, you choose the backup storage redundancy:
| Option | Description | Use Case |
|---|---|---|
| Locally redundant (LRS) | 3 copies in a single data centre | Development, non-critical workloads |
| Zone-redundant (ZRS) | 3 copies across availability zones | Production with single-region DR |
| Geo-redundant (GRS) | 6 copies: 3 local + 3 in a paired region | Production requiring cross-region DR |
Subscribe to continue reading
Get full access to this lesson and all 10 lessons in this course.