Add support for hosting the ConfigMgr DB on a Basic Availability Group (Always On)
Always On Basic Availability Groups provide a high availability solution for SQL Server 2016 and SQL Server 2017 Standard Edition. A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) Always On Availability Groups (SQL Server) with Enterprise Edition.
ConfigMgr now requires read access to secondary replicas, which is only available in the Enterprise Edition of SQL Server.
Kenneth van Surksum
shared this idea
3 comments
-
Vladimir Zelenov commented
SQL Server Standard Edition is a part of System Center license. Too many companies use ConfigMgr as non-business critical service and SQL Server Enterprise is expensive for it. Business don't want to pay this cost for HA and it starts to be a pain for system administrators.
-
Steve Thompson
commented
Now that SCCM HA is available, SQL Server Basic AOAG (Standard edition), is needed to provide SQL HA. For a client to implement SCCM HA, with SQL AOAG (SQL Enterprise), they would need THREE (3) new servers!
If SCCM could support SQL AOAG (2 node basic - std edition) , the client would only need ONE (1) new server to have SCCM HA and SQL HA. Thanks for posting this Kenneth!
-
ConfigMgr has it's own way of development :( All other System Center products have the support of BAG.