Stack Overflow
Stack Overflow

Questions tagged [availability-group]

35 questions
6
votes
2 answers

How to synchronize SQL Server Agent jobs across availability group replicas on Linux?

I have two SQL Server 2019 instances running on Linux. These two instances both contain a single database which is synchronized using AlwaysOn Availability Group. Data in the database is synchronized, but the problem is that the SQL Agent jobs are…
Andrej Lucansky
  • 725
  • 10
  • 17
6
votes
1 answer

How to correctly setup the connection string to availability group for legacy app

Imagine you have the following scenario: A .net framework 2.0 legacy client app. An SQL Server 2016 Always On Availability Group. How the connection string should be? I can think on two options: Specify the availability group listener name as the…
Jesús López
  • 8,338
  • 7
  • 40
  • 66
2
votes
0 answers

SQL Server AG on Kubernetes

I have a Kubernetes cluster and I deploy SQL Server Always On Availability Groups operator on it, but after 2 or 3 days the SQL Server pods get restarting rapidly and they don't work till I delete these pods and they deploying by the Statefulset…
meisam bahrami
  • 107
  • 1
  • 8
1
vote
1 answer

Databases stuck in “Synchronized / In Recovery” mode after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). Recently, I added another server to the AG, but…
Alberto Medina
  • 111
  • 1
  • 5
1
vote
1 answer

Availability Group synchronous commit - Write / Read Question

we configured for our customer a avalabilty group with synchronous commit mode and two cluster. One cluster is the primary cluster and is writable and readable. The other cluster is the secondary cluster and is only readable. We use the secondary…
Alexo
  • 131
  • 4
  • 15
1
vote
0 answers

Failover in SQL Server 2017 with Availibility Group

I'm configuring a failover in an above-mentioned setup with two nodes and synchronous commit. It's a test setup. Primary is server1 and secondary is server2. I configured the availability group and added the database. When I manually execute a…
Eduard Bader
  • 11
  • 1
1
vote
0 answers

Making sense of Windows sql availability groups, failover cluster, and load balancer

I am having issues with creating a failover cluster with an availabilty group. I've made a windows failover cluster, and a sql availability group. I also have an azure load balancer with an IP address and a DNS name. I am trying to follow this…
Sean Sullivan
  • 329
  • 3
  • 6
  • 17
1
vote
1 answer

snapshot isolation error using sp_setapprole on a read-only Availability Group replica

I am investigating SQL Server Always On Availability Groups and ran into a problem when setting an application role on the read-only replica database. What really irritates me is the behavior, and I don't know how to interpret the error message. All…
TRue
  • 11
  • 3
0
votes
0 answers

Azure DevOps Release Pipelines Detect Availability Groups

We have an Azure DevOps classic release pipeline setup to deploy SQL code to our SQL Server databases via SQL query files. We're running into an issue due to our databases setup with Availability Groups - when we create a release and deploy to our…
bbeck
  • 13
  • 3
0
votes
0 answers

SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)

We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance runs two instances of SQL Server (one for OLTP and one for OLAP). For maximum HA, but to keep costs…
sdaly
  • 1
  • 1
0
votes
0 answers

Transactional replication on dedicated server using AG Listener

I have dedicated server to setup transactional replication. i want to replicate 3 tables only Availability Database. The tricky part is, I want my transactional replication to continue automatically if automatic failover happen. Is there any way to…
zul nasir
  • 1
0
votes
0 answers

How is data loss possible if we lose primary in Read-Scale (clusterless) AG Sync-commit configuration (SQL Server AlwayOn)?

Microsoft documentation for Read-Scale (clusterless) failover: "If the primary replica is not available and can't immediately be recovered, then you need to force a failover to the secondary replica with data…
qqq
  • 1
  • 1
0
votes
0 answers

Cross database query with databases in different availability groups

Cross database querying if both databases are in the same AG is easy. We just use standard 3 part naming: SELECT t1.ID FROM [database1].[dbo].[table1] t1 JOIN [database2].[dbo].[table2] t2 ON t1.ID = t2.ID How does this work, or can it work if…
planetmatt
  • 407
  • 3
  • 10
0
votes
0 answers

How can I handle multiple linked server definitions that point to the same dacpac in a SQL Project?

One of the things that bugs me about SQL projects is that there are perfectly legitimate scenarios than can be done on a database server than cannot be done in a project. The latest example of this has to do with linked servers. I have many…
nicedream
  • 21
  • 1
  • 3
0
votes
0 answers

MSSQL AG Listener - possible to setup listener for multiple replicas?

Is it possible to setup AG in sucha a way that Listener will work for 3+ replicas? I'd like to be able to connect to database using Listener, not matter which replica is Primary one, but I'm not understading how this should work. Here's my setup in…
gluetornado
  • 35
  • 5
1
2 3