Azure Classroomnotes 09/May/2023

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
  • Retention Period:
    • By default 7 days
    • PITR (Point in time restore) can be changed between 1 to 35 days
• 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