Skip to content

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.

-->