Stack Overflow
Stack Overflow

Questions tagged [availability-group]

35 questions
0
votes
0 answers

Azure VM SQL Availability Group Listener Connection Problem

We are building a two-node SQL Availability Group with SQL Server 2016 SP3. Steps taken: 1.) Build two VMs in Azure in the same region, but different Zones 2.) Install Windows Failover Cluster on both nodes 3.) Install SQL Server 2016 SP3 on each…
Garry B
  • 211
  • 1
  • 3
  • 14
0
votes
1 answer

Can't Enable Always on Support for SSISDB

I need to set up Always on Support for SSISDB and I am receiving this message: The operation cannot be performed on database "SSISDB" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on…
SleepingSidewinder
  • 9
  • 2
0
votes
0 answers

I am not able to login with Windows Authentication in SQL cluster scenario (Always on high availability)

I am using SQL Cluster scenario with Always on high availability scenario. Everything works fine with the SQL Authentication but it is not working with the windows authentication. The connection string I am using…
Azaz ul haq
  • 53
  • 10
0
votes
2 answers

Issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated

I have an issue on 2016 where Last_sent_time and Last_received_time columns in the DMV dm_hadr_database_replica_states does not get updated. Coincidently we are seeing issues related to timeouts when the times are finally updated which makes me…
Lee
  • 13
  • 1
  • 4
0
votes
1 answer

For connection strings, in a High Availability setup, how does the routing work?

i believe partially the answer is, it connects to a listener server which redirects to a real database. say for example, a connection string is data source=SQLCL01;initial catalog=UserDatabase;user…
Luke
  • 194
  • 3
  • 10
0
votes
1 answer

SQL Server Availability Groups Usecase - 2 AGs on 1 machine

My knowledge about AG is very limited and I'm not a DBA. We have 4 machines - each of them is hosting two databases, say DB1 and DB2. DB1 is has its own AG (say AG1) which is replicated to other 3 machines, and DB2 also has its own AG (say AG2)…
Sanjeev Dhiman
  • 1,169
  • 1
  • 11
  • 20
0
votes
0 answers

Connecting to Availability Group Listener using JDBC getting error

I am getting the below error when my application tries to connect using AG Listener thru JDBC. Multisubnetfailover=true has been added to the connection string, but it is still not working. TCP/IP connection to the host , port 1433 has failed.…
Jaytee
  • 1
  • 1
0
votes
0 answers

SQl Server 2017 - Availability groups AND "replication" of special tables to warehouse?

We have a production DB with 10k tables (4TB). It is currently in an availability group so all the data is being streamed to a replica copy - mostly for redundancy. We want to make a dedicated data warehouse with the important tables ... cleanup…
Jon Blomiley
  • 1
0
votes
1 answer

Availability group restore and reseed

Is it possible to restore the database backup on the primary replica of availability group and then reseed it to the secodary replica without coppying backup files? Preferably I need to get the script (not GUI) that does it. So far I'm doing…
Maris Mols
  • 334
  • 1
  • 2
  • 10
0
votes
2 answers

Transaction log backup does not shrink after removing from Always on - log_reuse_wait_desc "availability replica"

Transaction log keeps growing and cannot be shrunk after taking the database out of availability group. when I check the log_reuse_wait_desc, it says “availability replica”. but the Database has been removed from AG. I am confused and not sure what…
Bala
  • 1
  • 1
0
votes
1 answer

SQL Server Always On Availability Group stuck in "Synchronizing / In Recovery"

I'm trying to create an Always On AG between SQL Server 2017 and SQL Server 2019 instances with a very simple database (just a single table test database for proof of concept). Everything appears to work fine except the secondary replica is stuck in…
alterant
  • 3
  • 2
0
votes
1 answer

Can I install MABS in a server which is node in a wsfc cluster which I'm using for Availability group? If not then why?

In MABS documentation (https://learn.microsoft.com/en-us/azure/backup/backup-azure-microsoft-azure-backup) It's written that we can't install MABS on a computer which is node of a cluster so I just wanted to make sure that I'll need additional…
hg1735
  • 1
  • 2
0
votes
0 answers

Sql Server replication setup in a high availability clustering system running on a workgroup

We are trying to set up replication for a database in a high availability cluster environment, where an outage of the primary database server will automatically fail over to the secondary server. Furthermore, we are using a workgroup-based…
Richard B. Sorensen
  • 103
  • 1
  • 12
0
votes
1 answer

Invalid value for key 'applicationintent'. (System.Data)

I have installed SQL Server 2017 on Windows Server 2012 R2. The servers are clustered under WSFC and SQL Servers are in availability group with configured availability group listener. Availability group is working fine. I've installed SSDT on all…
MohammadMBR
  • 13
  • 3
0
votes
0 answers

Failed to add replica to availability group : different sql server editions

I have 2 sql instaces with 2016 SP 2 I verfied the version on both servers and make sure they are identical but still cannot add replica because of this error the result of @@version on both servers full error message
Lana
  • 148
  • 1
  • 3
  • 12
1
2
3