Questions tagged [basic-availability-groups]

Filter by
Sorted by
Tagged with
0
votes
2answers
20 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
61 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
32 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 ...