Questions tagged [basic-availability-groups]

Filter by
Sorted by
Tagged with
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 ...
Keith Clark's user avatar
0 votes
0 answers
172 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 ...
Kalusql's user avatar
0 votes
1 answer
58 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 ...
variable's user avatar
  • 3,599
0 votes
2 answers
266 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 ...
Mandeep Singh's user avatar
0 votes
1 answer
480 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. ...
variable's user avatar
  • 3,599
3 votes
1 answer
1k 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 ...
Mbrouwer88's user avatar
2 votes
3 answers
251 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 ...
Joe Obbish's user avatar
  • 32.2k
1 vote
1 answer
759 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 ...
MichaelD's user avatar
  • 563
0 votes
1 answer
299 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 ...
SQL_NoExpert's user avatar
  • 1,049
0 votes
1 answer
1k 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 ...
Simonn's user avatar
  • 1
2 votes
1 answer
561 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 ...
Rob Dalzell's user avatar
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 ...
dhchen's user avatar
  • 113
1 vote
1 answer
1k 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 ...
Stockburn's user avatar
  • 419
0 votes
2 answers
248 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 ...
dhchen's user avatar
  • 113
2 votes
1 answer
57 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 ...
Yu Sasaki's user avatar
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 ...
Madi's user avatar
  • 11
0 votes
1 answer
1k 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 ...
JoshHill's user avatar
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 ...
BlakeC's user avatar
  • 11