Questions tagged [basic-availability-groups]

Filter by
Sorted by
Tagged with
1
vote
1answer
35 views

SQL Always on High Availabity Groups Multi Subnet

SQL 2017 Standard in SQL always on two node Basic AG. There are two DNS records for the listener with the different subnet IP's The servers are across subnets and we have hit issues with an ...
0
votes
0answers
24 views

Domain Independent Cluster Error “Cluster network name resource…”

Windows Server 2019 SQL Server Standard 2019 3 Basic AG with listeners Setup: I have a domain-independent two-node cluster with a file share witness. Our nodes are not joined to a domain. I ...
0
votes
2answers
35 views

SQL Server Basic Availability Group: config-only replica?

In SQL Server Basic Availability Groups docs, I found this interesting line: Basic Availability Groups for SQL Server 2017 on Linux support an additional configuration only replica. What is a ...
2
votes
1answer
31 views

Should we manually failover again if the node which was originally a primary role and went down recovered?

We have an SQL Server 2016 standard edition with Basic Availability Groups(BAG) setup between dbserver1 and dbserver2. This is our first time to implement the BAG and wanted to know what to do in a ...
1
vote
0answers
42 views

Can I do a combination of SQL Server Basic availability groups with SQL Replication?

I need to use SQL Server Standard 2016 to keep the costs low but achieve HA. In addition we need to have two Read nodes for reporting purposes. I am wondering if I can use SQL Server Replication to ...
0
votes
1answer
107 views

Replication with Always On availability groups

I have a three server set up: SQL01 – Primary server SQL02 – Secondary server SQL04 – Remote distribution server SQL04 – Subscribe SQL01 / SQL02 DB's are part of basic availability groups and i am ...
0
votes
0answers
33 views

Availability Group Listener Loses Connectivity on Failover

I have 2 SQL server 2016 standard Servers. Production (SRV1). For reporting (SRV2) Both servers are nodes in WSFC. SRV1 replicates the production database (DB1) to SRV2 with the distributor ...