Backups in Azure SQL Database
- Azure SQl provides automatic backups which consits of
- full backup
- differential backup
- log backup
- First backup will be full backup and will be taken immedietly after database is created
- Differential backups are scheduled to occur every 12-24 backups
- Transactional log backups are scheduled for every 5-10 minutes
- Backups:
- Storage options:
- Locally redundant
- price: x
- Zone Redundant
- price: 1.25 times x
- Geo-Redundant
- price: 2 times x
- Locally redundant
- Retention Period:
- By default 7 days
- PITR (Point in time restore) can be changed between 1 to 35 days
- Storage options:
- Create an Azure SQL Datbase, Navigate to server and select the retention policies
Azure SQL Elastic pool
- Refer Here for elastic pool in Azure
Next Steps:
- Replicas
- Azure SQL Managed Instance