Azure SQL BCDR and Backups
-
BCDR in Azure SQL
- Geo-Replication
- Failover Groups
-
Backups:
- Automatically creates the database Backup.
- Strategy => Read-Access Geo-redundant Storage
- Backup Frequency
- Full Backup => Weekly
- Incremental/differential Db Backups => 12 hours
- Transaction log Backups => 10 minutes
- Due to above frequency, Azure SQL supports Point-in-time restore
- Restore from Backups
- Azure Database for MySQL and Postgres also have same backup frequency, automatic backups and recovery process as Azure SQL
- Azure Backup Service can be used for Azure SQL VMs
Backups For Azure Cosmos DB
- Azure Cosmos DB also automatically take backups
- Azure automatically takes a backup every 4 hours & only 2 latest backups are stored.
- Azure Cosmos DB stores these backups in Azure Blob storage
- Azure Cosmos DB Backups can be restored from online backups
BCDR Startegy for Simple Architecture
- For Azure VMs
- Replication => Using a Site Recovery Vault in target Region
- Backup => Using Azure Backup Service which inturn create a Site Recovery Vault in source Region
- For Azure SQL
- Replication => Use Geo-Replication/Failover Groups
- Backups => Automatic
- Azure Cosmos DB
- Backups => Automatic
Azure Bastion: A service to enable communication
- Azure Bastion is a Service offered by azure which eliminates the need for management subnet with one vm running to help connect to machines in private subnets
- How Azure Bastion helps in connecting Azure VMs
- For Pricing Refer Her