Business continuity of on-prem SQL Servers using Azure services through Arc
summary
Arc-enabled SQL Servers bring cloud features to on-prem systems immediately: Azure Arc collects inventory for availability groups and FCIs, shows health and replica roles, and initiates manual failovers from the Azure portal (preview). Automated backup preview offers automated backups with 5-minute log backups and configurable retention (0–35 days) and point-in-time restore; long-term retention is on the backlog. A dashboard example shows 7,000 databases with ~50% missing backups, and MI Link enables failover to Azure SQL Managed Instance for cloud DR and migration.
AI-written summary · about
chapters (13)
- 0:00Business continuity with Azure Arc
- 1:32Cloud migration challenges
- 8:53Arc solutions overview
- 12:27Arc SQL continuity features
- 15:36Deploying Arc agent
- 19:54Demo: availability group management
- 22:24Failover cluster inventory
- 24:08Business continuity for migration
- 28:45Monitoring disaster recovery
- 34:24Cloud-based continuity options
- 36:27Migration and DR assessment
- 39:15Real-time replication
- 42:25Resources and closing
related talks
22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit- 22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
50mArc, Arc and Arc: De-mystifying Azure Arc for Data
49mDell and Azure Arc-enabled data services - SQL MI Business Critical
46mAzure SQL Database Business Continuity During Disaster
01h 01mAzure SQL Database-Business Continuity During Disaster
48mSQL Server 2022 - the most Azure-enabled SQL Server yet
53mAzure SQL Anywhere: An Introduction to Azure Arc-enabled Data Services