Questions tagged [basic-availability-groups]
The basic-availability-groups tag has no summary.
21 questions
0
votes
2
answers
101
views
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 ...
- 361
0
votes
1
answer
107
views
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 ...
- 1,288
2
votes
1
answer
211
views
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 ...
- 1,288
-1
votes
1
answer
195
views
How is basic availability group able to auto failover without a cluster?
I have recently learnt that the SQL server standard edition's basic availability group doesn't require a windows cluster.
Basic AG is considered equivalant to the deprecated mirroring technology. Like ...
- 3,592
0
votes
0
answers
620
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 ...
- 1
0
votes
1
answer
157
views
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 ...
- 3,592
0
votes
2
answers
438
views
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 ...
0
votes
1
answer
707
views
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.
...
- 3,592
3
votes
1
answer
2k
views
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 ...
- 141
3
votes
3
answers
398
views
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 ...
- 33.1k
1
vote
1
answer
997
views
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 ...
- 573
0
votes
2
answers
452
views
Automatic Failover for Basic Availability Group [closed]
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 ...
- 1,117
0
votes
1
answer
2k
views
Always On Basic Availability Groups stuck as primary on both replicas
I configured Always on basic availability groups on my SQL Server 2019 Standard instances. One as our production machine and the second as a DR machine.
I have primary set to synchronous commit and DR ...
- 1
2
votes
1
answer
844
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 ...
- 876
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 ...
- 113