AlwaysOn Availability Groups
GPTKB entity
Statements (34)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
high availability and disaster recovery solution
|
| gptkbp:availableOn |
SQL Server Standard Edition (basic availability groups, limited features)
|
| gptkbp:developedBy |
gptkb:Microsoft
|
| gptkbp:documentation |
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server
|
| gptkbp:enables |
disaster recovery
high availability |
| gptkbp:features |
gptkb:Microsoft_SQL_Server
|
| https://www.w3.org/2000/01/rdf-schema#label |
AlwaysOn Availability Groups
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2012
|
| gptkbp:primaryReplica |
handles read-write operations
|
| gptkbp:replacedBy |
gptkb:Database_Mirroring
|
| gptkbp:requires |
gptkb:Windows_Server_Failover_Clustering
SQL Server Enterprise Edition (for full features) |
| gptkbp:secondaryReplica |
handles read-only operations
|
| gptkbp:secondaryReplicasCanBe |
readable
non-readable |
| gptkbp:supports |
automatic failover
encrypted connections asynchronous-commit mode manual failover readable secondary replicas synchronous-commit mode automatic page repair cross-datacenter deployments listener for client connections multiple databases per group up to 8 secondary replicas (SQL Server 2016 and later) |
| gptkbp:usedFor |
maintenance
reporting offloading backups |
| gptkbp:bfsParent |
gptkb:SQL_Server_2014
gptkb:SQL_Server_2014_and_later gptkb:SQL_Server_2012 |
| gptkbp:bfsLayer |
7
|