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
2answers
41 views

Migrating from old AlwaysOn Availability Group to new AG cluster but keep ip addresses

We want to migrate our SQL Server 2012 on server 2012R2 to SQL Server 2019 on server 2016 and keep the ip addresses but change hostnames. i can not change the name of listener and ip addresses from ...
-2
votes
0answers
42 views

Tempdb filling up on secondary always on server

Please advise . The tempdb disk fills up unexpectedly on secondary always on server . Is there a way to check what is causing or a way to prevent it ?
-2
votes
0answers
39 views

SSRS in Availability Group does not fail over correctly

I am trying to get my SSRS reports to work with an Availability Group setup. Currently it works on Node 1, but any time there is a failover to Node 2, the reports stop working until I fail back to ...
1
vote
1answer
26 views

AG failover successful, but old Primary node thinks its still primary after bringing back online

I am doing some testing on SQL 2017 Availability Groups and have the following setup: 1 SQL Clustered instance on a 2-node WSFC in DC1 1 standalone SQL node in DC2 There is 1 AG, containing 3 DBs, ...
3
votes
2answers
275 views

CPU cores and sys.dm_os_workers

We recently failed over our AOAG cluster to a secondary region. In the first region, our boxes had 32 cores while in the secondary region, we have 64 cores. Traffic is similar, however on the larger ...
0
votes
1answer
31 views

SQL Server - Is it a good idea to persist temporary stats built on AG read-only secondary?

I am curious if there are any benefits to running the below query every hour or even once a day to track whenever a temporary stat is created on an AG secondary/read-only replica and then having a ...
0
votes
1answer
46 views

Can Availability Group be configured in a below structure?

I have Production and DR clusters as depicted on a picture below. My question is whether there is a way to configure Availability Group from datacenter1 to datacenter2? I tried to configure regular ...
0
votes
2answers
79 views

AlwaysOn Availablity Groups and database count limits

Update: Basic answer: I asked for something that isn't part of the design of AOAG. Which in my eyes makes this a 'not a good question to ask'. Unless this offends someone, I'll keep it here in the odd ...
2
votes
1answer
44 views

What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?

I am setting up a 3-node Availability Group with 2 nodes on-premises and the 3rd on a VM in Azure. All nodes are SQL Server 2019 Enterprise with CU14. The Availability Group is fine and the listener ...
0
votes
0answers
36 views

Distributed Availability Group between a domain and a workgroup

I want to implement “Distributed Availability Group” on Windows Server 2016 and SQL Server 2019 and between a domain and a workgroup. I follow the steps that described in this link: https://docs....
2
votes
1answer
61 views

Availability groups across sites: what happens if severs can't contact each other but both still can reach file share witness?

I'm currently planning a new SQL Server 2019 Enterprise Edition setup with HA/DR, possibly with availability groups. Let say we have the following setup: Site A: one SQL Server instance (SQL1) Site B:...
2
votes
1answer
45 views

Transactional Replication vs AO for MS Sql Server

When we set up web servers in AWS, we have a load balancer which allows highly scalable performance improvements per instance provided. I would like something similar for MS Sql server. I have been ...
1
vote
1answer
61 views

Isolation level with SQL Server and Azure Sql Database Read-Only replica

I read here and here that, when connecting to a Sql Server read-only replica, the isolation level used is ALWAYS SNAPSHOT. It says it ignores SET TRANSACTION ISOLATION LEVEL statement and any locking ...
0
votes
1answer
44 views

Any idea what Virtual Machine Cluster WMI is for?

We have a Windows Failover Cluster to host our SQL Server Availability Group. We have a resource that popped up that no one recalls creating named "Virtual Machine Cluster WMI". We have ...
0
votes
0answers
21 views

Procedures to safely perform SQL Server Always On database cluster failover during Updates & Patching?

I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes. This is to perform the Windows Server updates that ...
0
votes
0answers
51 views

Linked Server Connection Issue to SQL Server AlwaysOn Listener

I have SQL Server 2008R2 Standard Edition. I am making a Linked Server connection to a Listener of an AlwaysOn Availability Group. However, when I run a query from SSMS I intermittently get this error:...
1
vote
1answer
99 views

SQL Server 2017 AlwaysOn Failover Cluster issue

I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2. there is no any running backup (SNAPSHOT) PROD : 10....
0
votes
1answer
21 views

Create availability group between FCI and standalone node

first question here so please advise if I've missed anything. I've read this question (AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC? ) but ...
1
vote
1answer
108 views

log_reuse_wait_desc = AVAILABILITY_REPLICA, log is 100% full but AG is all fine

That's a weird scenario. The transaction log is full. It waits on AG. AG is all good. No latency, last commit/hardened time is almost real-time on all the nodes. The Estimated Recovery Time is zero. I ...
0
votes
1answer
120 views

Intermittently failover of my SQL Server resources on Windows Server 2016

I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2016. Basically everything is pointing ...
0
votes
0answers
23 views

SSIS Why is "Enable Support for AlwaysOn wizard" coming up blank?

I'm setting up SSISDB into a AO on SQL Server 2017 enterprise. The AO i set some time ago and appears to work fine. I've added the database to they AO, dashboard is showing everything as green. ...
0
votes
0answers
28 views

Azure SQL Server two-node Workgroup Availability Group

I have two SQL Server VMs in Azure. They are not on a domain, they are in an Azure DMZ to remain secure. We currently are utilising SQL Mirroring for DR & patching purposes. However due to the ...
1
vote
1answer
65 views

SQL AAG Cluster - Diagnosing Partner Quorum Failure

Recently we had a failure of our SQL Server (2016) Always On Availability Group, where our fileshare witness node was briefly inaccessible to our two nodes due to a CPU spike. We have two SQL server ...
0
votes
2answers
215 views

SQL Server 2019 Always On - Ensure that cluster name object (CNO) is granted permissions to the Secure DNS Zone

I have here a SQL Server 2019 Always On with a lot of errors like this one: 2 nodes configured in a cluster with file share witness. Cluster name: SQLCLS Listener name: SQLLSN Event: Cluster network ...
0
votes
1answer
24 views

AlwaysOn availability group listener

There is a server with me that is already configured with AlwaysOn by somebody else. I am adding one more availability group to the server. Can I use the same availability group listener for the new ...
0
votes
1answer
41 views

Can we add FCI to AG or a single instance from FCI to AG?

I am exploring FCI and AG. In FCI we can have 2 nodes that share the same SAN storage. And failover results in the other node starting up. Where as AG is for a set of dbs. This question is about the ...
0
votes
0answers
32 views

Scheduling IBM Spectrum Protect (TSM) backups via IBM Workload Scheduler (IWS)

We are switching from CA7 to IWS scheduler. Currently, the SQL backups scripts are called from CA7 with no issue. That includes a couple of two node SQL Always On Availability Group (AOAG) cluster as ...
0
votes
1answer
55 views

Why I can't take differential backup of primary replica?

I am trying to take a differential backup of my primary database by connecting to the primary replica, but I can't do that. We use SQL Server 2017 EE with latest CU. Database is in full recovery model ...
0
votes
1answer
34 views

Offline Server Still has Quorum Vote

I have an Availability Group with 2 replicas. One replica is completely powered off. When I look at the cluster quorum info, the server that is powered off still has a quorum vote. How can that be? ...
0
votes
2answers
67 views

Memory configuration and exhaustion on Always On cluster

I have a 2-node SQL Server Always On cluster hosting 3 SQL Server instances and configured as follows: Total server memory is 768G for each nodes. Memory consumption is 98%. LPIM is activated. ...
0
votes
0answers
59 views

Why is the FILESTREAM data not accessible, after AG listener is created?

I'm having a hard time figuring out why my app can't access filestream data, after we enable AG listener. Background info: Initial environment: APP Server Web Server IIS Windows Server 2012 R2 DB ...
0
votes
1answer
47 views

Failover and Failback SQL server Distributed availability group with different versions

I know that SQL server Distributed availability groups can sync data between two different Major versions, Lets say Global Primary - 2016 Secondary AG - 2017 This sync will work and I can do failover ...
0
votes
1answer
206 views

SQL Sever Alwayson - Increase the WSFC failover threshold

Im trying to simulate the Failover in my SQL server 2017 alwayson by stopping and starting the SQL server service. It worked 2 times, but after that, the failover is not happening, It showing an error ...
0
votes
0answers
33 views

Hidden SQL server replica in always on availablity group

I want to deploy SQL server 2017 always on availablity group also with a replica for DR purpose. I want to use 1 primary(prod) 2 secondary(prod) 1 secondary(DR) Now my question is, the failover can ...
0
votes
2answers
23 views

SQL server 2017 distributed availability group connectivity after failover

I'm going to deploy SQL server distributed availability groups with SQL server 2017. From the documentation, I understand that we can have listeners for primary AG and secondary AG. The application ...
0
votes
0answers
41 views

script to detect alwayson redo latency in SQL Server

I have 2 node SQL 2019 AlwaysON setup where i regularly see latency for redo thread in AG dashboard when applying the redo transactions on secondary. we have identified that this redo thread delay in ...
0
votes
2answers
84 views

How to 'pause' SQL Server AlwaysOn Availability Group

We have two SQL Server nodes running in an AlwaysOn Availability Group. I'm looking for some suggestions and/or best practices on how to temporarily suspend connection or prevent users from ...
3
votes
1answer
196 views

Remove version ghost records of allocation type LOB_DATA without restarting the service or failing over

A database that is part of a SQL Server Always Availability Group with both synchronous and asynchronous readable secondaries that are being used to scale out read-only workloads is experiencing a ...
0
votes
1answer
39 views

Configure cluster on an existing SQL Server - to setup AlwaysOn Availability Groups

We are already having an SQL Server Enterprise Edition instance running on an Physical Server. Now to configure AlwaysOn Availability Groups Can we configure WSFC (Windows Server Failover Cluster) ...
0
votes
1answer
66 views

Error: While creating clusterless Availbility Group

I was trying to create Clusterless AlwaysON for SQL Server 2019 and getting the below error. Error Message: Msg 47106, Level 16, State 3, Line 11 Cannot join availability group '100'. Download ...
0
votes
1answer
182 views

SQL Server always on servers reboot

I have the below set up for availability group : Always on configured in SQL Server 2017: Primary is read write and secondary is read only. Both primary and secondary are configured with asynchronous ...
0
votes
1answer
53 views

Can we use Suspend data movement as a Rollback Plan in AOAG

We have an always-on setup...we are doing some reprocessing of data and as part of that activity, we will be suspending the data movement between primary and secondary before making the changes on ...
0
votes
0answers
42 views

Preventing read access for users connecting to primary replica and allow access only on secondary replicas [duplicate]

I have a requirement where Read only users group should not be able to access primary replica at all and group should have read access only through secondary replicas. I setup applicationintent=...
1
vote
1answer
78 views

Fix a broken secondary on a SQL availability group

I'm having trouble finding the proper steps for what I would think would be a pretty routine task: My SQL availability group secondary is no longer synching, and I need to get it working again without ...
1
vote
1answer
93 views

Rollback options for a one-way SQL server AlwaysOn - rolling upgrade SQL server + Windows OS upgrade

We are thinking about an upgrade of our Windows 2012 R2 + SQL server 2012 failover cluster and AlwaysOn availability group. Microsoft has guidelines for the SQL upgrade and for the failover cluster ...
1
vote
1answer
94 views

How to Reconnect Apps to a Different Listener in a SQL Server Distributed Availability Group

I have created a SQL Server Distributed Availability Group (AG), which spans two underlying AGs, each of them deployed on a Windows Cluster at a different location. I have also created a Listener for ...
0
votes
0answers
27 views

Availability Group Backups For Ola H.'s Software

Using the Ola Hallengren's DatabaseBackup software on a SQL Server 2016 AG. Trying to use copy-only and tran log backups on secondary node, with Backup Preference set to 'Prefer Secondary'. Given ...
1
vote
1answer
31 views

Always On with multi AGs primary on each replica - Any gotcha's?

I have a bunch of Always On clusters that I manage and am really comfortable with them. I have one client who is running an Always On cluster with 2 replicas. They have 4 AG's that each have their ...
0
votes
0answers
35 views

Failing Over on the Fisrt SQL Server AG at one Location breaks the Distributed AG at the Second Location

I have configured a SQL Server Distributed Availability Group (AG), containing a Windows cluster with an AG at one location, and a second cluster with its own AG at another location (thus, two AGs). ...
0
votes
1answer
42 views

Can you omit a database from one replica of an Availability Group

Question: Is it possible to add a database to specific replicas of an availability group and not add it to another replica? Use Case: A production database is required for operations but does not need ...

1
2 3 4 5
28