Question : In SQL Server Basic Availability Groups docs, I found this interesting line: Basic Availability Groups for SQL Server […]
Tag: basic-availability-groups
SQL Server Basic Availability group: one or zero listener for multiple AG
Question : In my testing of SQL Server 2019 Basic Availiiblity Group on Ubuntu 20.04, I successfully created AG1 for […]
Always On Basic Availability Groups stuck as primary on both replicas
Question : I configured Always on basic availability groups on my SQL Server 2019 Standard instances. One as our production […]
Unable to create Always On Basic Availability Group on SQL 2019 Standard, cannot enable Always On feature
Question : I want to create a SQL 2019 Standard BASIC Always On Availability Group for a database in a […]
Should we manually failover again if the node which was originally a primary role and went down recovered?
Question : We have an SQL Server 2016 standard edition with Basic Availability Groups(BAG) setup between dbserver1 and dbserver2. This […]
SQL Always on High Availabity Groups Multi Subnet
Question : SQL 2017 Standard in SQL always on two node Basic AG. There are two DNS records for the […]
Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?
Question : We have a few Basic Availability groups in production and I’ve been reading about the limitations of them. […]