Azure Databases Contd

Azure SQL Database Server Options

• Data Management
  
• Backups
  
  
  
• PITR durations will differ based on Database Purchasing models
• Restoring Database from Available backups Creates a new Database in same server

Configuring Auto Failover

• Failover Groups: The Failover group helps setting up failover i.e. when the primary server is not responding the the secondary will start acting as primary.
  
• Create a new SQL Server in other region
  
• Now create a failover group
  
  
• Failover Details
  
  

Terms

• Full Backup
• Incremental Backup
• PITR (Point In Time Restore)