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)
