Questions tagged [availability-groups]

Availability Groups are a new feature of SQL Server 2012 that provide continuous data synchronization, automatic failover and secondary read access for one or many SQL Server databases.

Filter by
Sorted by
Tagged with
0
votes
1answer
14 views

SSRS subscriptions after failover

Shortly I will be migrating a 2008 R2 SSRS installation to a new SQL 2019 Always on AG in AWS. This one will contain subscriptions, and I have never dealt with them before. I read the documentation ...
1
vote
1answer
61 views

Why does the log file grow larger than data file for an availability group database on the secondary replica?

I've got a SQL Server 2016 AG set up with only two replicas (primary and secondary). Both synchronous, non-readable secondary, and backup the primary only. Transaction Log backups occur on the primary ...
2
votes
3answers
263 views

Will SQL Server go offline if it loses network connectivity to SAN where master and msdb system databases reside?

I have a setup where 3 servers combined into Availability Group All 3 servers have local directly attached SSD drives, and user database files are hosted on these drives But the system databases (...
-1
votes
1answer
31 views

Availability Group is not failovering when a cluster core resource is failedover

I have created always on availability group.The cluster core resources failover is happening. The availability group (Automatic) failover is happening. But, when the cluster core resource is failed ...
0
votes
1answer
27 views

Always On Instance Service Broker/Database Mirroring transport connection endpoint Error

I have a production instance that has 2 AOG. There is no mirroring configured for both groups. Both groups are also in 'Healthy' state. Upon checking the error log on SQL Server, I noticed that ...
0
votes
1answer
22 views

Does listener gets affected when we replace secondary replica with another server in Availability Group?

I have created Multi Subnet Always On Availability Group. Now, I need to replace secondary replica with another server in Availability Group. In this case, Do I need to re-create listener? OR The ...
0
votes
1answer
19 views

AAG trigger a query when failing over

I'm running a Failover cluster on windows 2016 servers (2 nodes) where I set up an AG in SQL 14.0.2027.2 This works good and I'm happy. But when it failover I need to fix my logins so I need to run a ...
0
votes
1answer
52 views

is Sql Server AlwaysOn AG a multi-site active-active replication technology? [closed]

Scenario FCI: I understand multi-site active-active replication in SQL Server can be installed with an FCI (Failover Cluster Instance). The replication part occurs at the storage level with a ...
0
votes
1answer
29 views

what will cause a sql server AG readonly replica to stop serving readonly clients?

I understand that if a failover happens (among any nodes in an AG), then all nodes lose their existing connections. And I assume that if a primary suspends data movement, that will have no effect on ...
2
votes
2answers
40 views

behavior of a Sql Server availability group listener and a jdbc client during a failover?

i have a question about the behavior of the AG listener during a failover... when the failover happens, I realize that all the connections on both primary and secondaries are closed. if the client ...
0
votes
0answers
25 views

SQL Server 2019 AlwaysOnAG DBCC CHECKDB on synchronous replica setup as not readable

I've seen answers in this exchange that say DBCC CHECKDB should be able to run on AOAG synchronous replicas that are not open for read. That MS fixed that because it was a bug in 2016. I'm using SS ...
1
vote
3answers
36 views

Always On Availability Groups on single VM

Is there any way to implement Always On Availability Groups using SQL Server 2019 Enterprise Edition on a Single Virtual Server. The goal is not to have any HA or DR capability, but merely Read-Scale ...
1
vote
1answer
37 views

Multiple differences of opinion about transaction log autogrowth settings

We have a two-node SQL Server 2017 AG. There's a job that looks at autogrowth settings for our databases and makes sure they're not set to use a percentage. For the past day, its been continually ...
2
votes
1answer
30 views

TransactionLog not getting truncated in AlwaysOn Cluster

Folks, stuck with a wierd transaction log truncation(reuse) problem in an AlwaysOn cluster and running out of options, the transaction log is not getting truncated and keeps growing. Only one database ...
0
votes
1answer
28 views

Which is the best approach to “suspend” the activity of a whole AOG cluster thinking on start it again later?

My company is going to migrate some services from one on-prem site to another but the database servers will remain in the same location (for now). I've been asked for "suspend" all the ...
0
votes
1answer
27 views

Downgrade SQL Server from Enterprise to Developer edition in an Availability Group

I will be transitioning some non-production SQL environments from Enterprise to Developer edition over the next few months. I'm pretty settled on the procedure I will be using, which is laid out in ...
1
vote
1answer
135 views

Error Failover in Always on high availability groups

We have a problem with Always on high availability groups in Microsoft SQL Server 2016 (SP2) , When we want to failover to the secondary node manually, it fails because of this error: Failed to ...
0
votes
1answer
27 views

multisubnet listener

Good morning all , I have an alwayson instance with a multisubnet listener I configured RegisterAllProvidersIP = 0 in order to register a single DNS entry HostRecordTTL is configured at 1200 seconds I ...
1
vote
2answers
28 views

SQL Server 2017 Availability Group Deployment - Some availability replicas are not synchronizing data

I'm in the process of configuring my first cluster using SQL Server 2017's availability groups. I have some experience with SQL Server failover clusters, but wanted to migrate to the Availability ...
0
votes
1answer
107 views

SQL Server AlwaysOn: Lost of heartbeat and connection with secondary replica

Virtual Enviroment description: Hypervisor: VMWare WSFC composed by two nodes with Windows server 2016 Standard SQL Server AlwaysOn with synchronous replica and automatic failover SQL Server 2014 (...
1
vote
1answer
33 views

Why am I seeing poor performance on SQL server 2019 and asynchronous AlwaysOn

I have recently migrated a 2008 sql dB that’s about 170 GB to 2019 with asynchronous always on. The application that uses this dB hits it pretty hard and I’m seeing an increase of about 2 ms on every ...
0
votes
1answer
63 views

The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted

One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes. End users are getting some error in the application that always point to the same error ...
2
votes
1answer
54 views

AlwaysOn failover DR testing

I have always-on group running on 4 node cluster. Each DC has 2 node running on it Data Center1: Node1: Sync Replica - Automatic failover Node2: Sync Replica - Automatic failover Data Center2: ...
0
votes
3answers
55 views

Sync two sql server database(Active/Active) Mode

I have two sql server(SQL2016) Production-1 and Production-2 under one cluster with same database.I need real-time sync between both databases simultaneously like what ever changes in either A or B ...
0
votes
1answer
58 views

“Test-SqlAvailabilityGroup” takes too much time

Can anyone explain me why the command Test-SqlAvailabilityGroup takes too much time ? Is there a fastest way to check if a an availability group exists or not (preferably on PowerShell) ? Thanks.
0
votes
1answer
24 views

Biztalk in alwayson SQL 2019

Good morning all I am working on a Biztalk migration project On an alwayson SQL environment Who has an idea if BIztalk is compatible with ALWAYSON if YES it is from Which version? another question for ...
-1
votes
3answers
108 views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
3
votes
1answer
66 views

SSISDB master key in an Availability Group

I activated Always On support for SSIS and everything works fine until a fail over operation happens. Turns out the secondary nodes have a different service master key than the primary node and after ...
1
vote
1answer
38 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 ...
5
votes
2answers
295 views

Availability Group - how much data was lost after forced failover

Let's consider a SQL Server AlwaysOn cluster with two nodes in asynchronous replication. Is there any way to calculate how much data was lost after forced failover? I mean in terms of time, to be able ...
0
votes
1answer
37 views

seeding mode in SQL Server 2019

Does activating the TF9567 seeding mode trace flag speed up the synchronization process in AlwaysOn? I am using SQL Server 2019.
0
votes
0answers
24 views

AOAG windows 2 node cluster in confusion

We have a 2 node cluster alwayson availability group running with 4 resources/roles. due to VM backup one of the node lost connectivity to node 2 and it marked node 2 as removed from cluster and tried ...
0
votes
2answers
88 views

Resource Hosting Subsystem was terminated which caused Availability group to fail

The following error was occurred in cluster events and the availability group was failed which resulted the databases in non-synchronizing state. A component on the server did not respond in a timely ...
0
votes
1answer
26 views

SID for SA account

I want to change the SA password for the always on availability group servers. Since i wanted to keep the same password on all the replicas when I tried to transfer the login through Microsoft Stored ...
0
votes
0answers
67 views

multisubnetfailover=yes and registerallipprovider = 0

I have a multi-subnet availability group. The application connection string specifies multiSubnetFailover=Yes And availability group listener network has parameter set RegisterAllProvidersIP=0 ...
0
votes
1answer
35 views

Sync logins and Agent jobs across all replicas in Distributed Availability Group

I am using dba_CopyLogins stored proc to sync logins on replicas in Distributed Availability groups, but the database level permissions are not transferred due to database sync operation is going on.. ...
1
vote
1answer
29 views

Upgrading SQL 2016 AGs to SQL 2019 question

I am doing a rolling upgrade of my production SQL 2016 Servers to SQL 2019. I have availability groups. My current structure is 3 DR servers (secondaries), 3 HQ (on prem) secondaries and 3 HQ ...
0
votes
1answer
17 views

Web server accessing the database server in Always on availability group

We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
1
vote
1answer
54 views

Troubleshooting slow connection establishment

The client and the server are running on Windows on different subnets. I'm facing a 20s delay to establish a connection to a SQL 2012 Always On availability group using .NET Core Sql client using sql ...
0
votes
1answer
29 views

activate Service Broker on a database in an Availability Group

I found some older posts dealing with this(5 yrs old or more), but I am confused on the process or if this information is out of date, hence my new question. I am on sql 2016 SP2-CU11 enterprise. I ...
2
votes
1answer
35 views

Upgrade with DistributedAG vs adding a node with SQL Server 2019

We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of an Availability Group. I added a new replica using SQL Server 2019 on a new node and made that replica ...
0
votes
0answers
23 views

Non-Domain Account Error while Creating Availability Group

I am creating Availability Group with two node cluster. Both servers are using same service account for SQL. But, while creating Availability Group, I getting that the SQL service account is using non-...
0
votes
0answers
14 views

Difference between AlwaysOn with 'WSFC' as the Cluster Type and 'AlwaysOn Failover Clustering'?

Per what I understood: Clustering is used for HA, where you can failover automatically, and it should be fast since the DB files are in a shared disk, so it would just be “reconnecting” the disk to ...
2
votes
1answer
113 views

log send queue size and redo queue size in AG

I am trying to figure out the way to monitor these 2 events log send queue size - I can see this in perfmon Redo queue size - I can see in dmv but not in perfmon counter Is there any way of using ...
2
votes
2answers
27 views

Can 'clustering' and 'alwayson failover clustering' be used interchangeably?

I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter. In 'hot', when citing the examples the author writes 'Clustering'. But when each technology is explained it ...
0
votes
2answers
40 views

Always On Synchronous Commit Mode With Large Delays [duplicate]

For SQL Server Enterprise's Always On availability groups in Synchronous Commit mode, is there some amount of latency that can't be exceeded? For example, can it work between very distant data ...
3
votes
1answer
40 views

Azure Readable Secondary - How to: Different Access Policy to Primary?

We have primary databases. They are in a mix of elastic pool, and standalone. We have successfully created active geo replicated secondaries. (Our use for these is solely workload isolation.) We want ...
0
votes
1answer
54 views

Timeout for Always On Synchronous Commit Mode

For SQL Server Enterprise's Always On availability groups, how can you configure the timeout for Synchronous Commit mode? Is there a maximum? Can it work, for example, between continents? Thanks
0
votes
1answer
16 views

Can we configure local and azure servers in a WSFC for Always On Availability Group? [closed]

Can we configure a local server and an azure server as a two node cluster for Always on Availability Group? Thanks!
0
votes
0answers
13 views

AlwaysOn Availability listener access issue

Good morning all , Who has any idea how to do create an SQL alias on a listen alwayson which uses a port other than 1433 thanks

1
2 3 4 5
26