Questions tagged [basic-availability-groups]
The basic-availability-groups tag has no usage guidance.
7
questions with no upvoted or accepted answers
2
votes
1
answer
563
views
DB_CHAINING lost on on planned Availability Group failover for SQL Server 2019 cumulative update
I'm looking for ideas on how to determine a plausible root cause for DB_CHAINNG problems encountered when we recently performed a planned AG failover.
We're using SQL Server 2019 Standard Edition with ...
1
vote
2
answers
1k
views
SQL Server Basic Availability group: one or zero listener for multiple AG
In my testing of SQL Server 2019 Basic Availiiblity Group on Ubuntu 20.04, I successfully created AG1 for DB1 and AG2 for DB2 with only AG1 config'ed with listener IP. But when I use sqlcmd to test, I ...
1
vote
0
answers
50
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
0
answers
14
views
Running DBCC on NON-READABLE replica
Since the system databases are not duplicated in a AG environment, I want to be able to run DBCC on them on a weekly basis and I would also like to be able to run DBCC on any databases where the AG ...
0
votes
0
answers
179
views
When I connected SQL Server 2019 Management Studio Connection to Integration Services it shows me Error Class Not Registered
I'm installed SQL Server 2019 Enteprisse in the first server and I have other server with SQL Server 2019 Standar Edition ,both server when I tried connect with the Integration Service SQL server 2019 ...
0
votes
1
answer
300
views
Automatic Failover for Basic Availability Group
This will be my first project with Basic availability group so I thought would check before implementing .
As per Microsoft documentation below it says we will need to have Software assurance for ...
0
votes
0
answers
92
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 ...