SQL DB¶
- Azure SQL Managed Instance is a fully managed, Azure-based version of SQL Server that can be used to host your on-premises SQL Server database in the cloud.
- It supports the deployment of multiple secondary, read-only replicas and can automatically replicate data between primary and secondary replicas.
- It also supports failover between primary and secondary replicas within a 15-minute RTO, which meets the requirement for the solution to have a recovery time objective of 15 minutes.
Always On AG¶
The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
Introduced in SQL Server 2012 (11.x), Always On availability groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to eight sets of corresponding secondary databases.
Optionally, secondary databases can be made available for read-only access and/or some backup operations.