Questions tagged [basic-availability-groups]
21 questions
3
votes
1 answer
Unable to create Always On Basic Availability Group on SQL 2019 Standard, cannot enable Always On feature
I want to create a SQL 2019 Standard BASIC Always On Availability Group for a database in a 2-node cluster.
By following this guide that should be possible although there are limitations compared to Enterprise…
Mbrouwer88
- 141
- 5
3
votes
3 answers
Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?
We have a few Basic Availability groups in production and I've been reading about the limitations of them. I'm concerned about the following limitations:
No backups on secondary replica.
No integrity checks on secondary replicas.
Suppose that we…
Joe Obbish
- 32,976
- 4
- 74
- 153
2
votes
1 answer
Do Basic Availability Groups have any benefits not found with Database Mirroring?
Assuming SQL Server 2022 Standard Edition on Windows, I simply cannot see any benefits to using Basic Availability Groups instead of Database Mirroring. Is there anything offered by Basic Availability Groups but not Database Mirroring?
In both…
J. Mini
- 1,161
- 8
- 32
2
votes
1 answer
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 "Basic" AGs (meaning that every database is in…
Rob Dalzell
- 856
- 7
- 12
2
votes
1 answer
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 failover scenario like below:
In the beginning,…
Yu Sasaki
- 23
- 4
1
vote
1 answer
High availability primary does not automatically take secondary role when back online
Setup:
Basic high availability
2 replicas (1 primary, 1 secondary).
DB01 => initial primary.
DB02 => initial secondary
Synchronous commit on both
Both are in synchronized state
There is no listener configured
Cluster type None
When we stop…
MichaelD
- 573
- 2
- 13
1
vote
2 answers
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 can connect to AG1's listener and use AG2's DB,…
dhchen
- 113
- 6
1
vote
1 answer
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 application seeing to randomly time out when talking to the…
Stockburn
- 501
- 4
- 22
1
vote
0 answers
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 get data for the two Read nodes. Is it possible to…
Madi
- 11
- 1
0
votes
2 answers
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019. This is a basic availability group running in a cluster-less installation.
In the dashboard I see this:
This is the error I get:
I also checked…
Russ960
- 361
- 4
- 14
0
votes
1 answer
How can I know that it is safe to failover a Basic Availability Group?
Today, I learned the hard way that you cannot corruption check a Basic Availability Group's secondary. Given this limitation, how can I know that it is safe to failover a BAG? For all I know, the secondary could be corrupt.
J. Mini
- 1,161
- 8
- 32
0
votes
0 answers
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 .It shows me the error:
Connecting to the…
Kalusql
- 1
- 1
0
votes
1 answer
When using multiple basic AGs is it recommended to use 1 listener or mirroring endpoint?
I want to setup HA DR for a single instance SQL server by adding a new instance on another machine and configuring multiple basic AGs (with manual failover mode).
I want all client apps to be able to use the same connection string to reach the…
variable
- 3,590
- 4
- 37
- 100
0
votes
2 answers
SQL - Transactional Replication between existing databases
I want to reconfigure a Dynamics AX 2012 SQL Server to improve performance of an existing architecture where one SQL server is used for both transactions and reports. This reduces SQL performance during peak loads (large MIS report generation).
In…
Mandeep Singh
- 3
- 4
0
votes
1 answer
Can I use SQL AG to create readable secondary when primary is enterprise and secondary is standard edition?
1 have 2 sql servers.
Svr1 is enterprise edition and Svr2 is standard edition.
Both have their own independant FCI.
Svr1 has got 60 production dbs. Svr2 has got 10 reporting dbs and multiple etls.
Presently the etls running on Svr2 fetch data from 5…
variable
- 3,590
- 4
- 37
- 100