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
2
votes
1answer
49 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
35 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
56 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
22 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
35 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
61 views

SQL Server 2017 AlwaysOn Failover Cluster issue

I have 2 Windows 2012R2 VM's running on Vmware ESXi 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) ...
0
votes
1answer
20 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
84 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
65 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
19 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
27 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
51 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
88 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
23 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
33 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
27 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
52 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
62 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
48 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
42 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
144 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
22 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
39 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
71 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
180 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
57 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
108 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
51 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
41 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
72 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
77 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
82 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
24 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
30 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
38 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
vote
1answer
42 views

Using CName to point to the Availability Group listener

I have SQL Server 2008 named "OldSQLServer". Its data is accessed by hundred of SQL Servers via linked server. I am moving the "OldSQLServer" to AG on SQL Server 2019, windows 2019....
0
votes
1answer
45 views

SQL Server Installation for a Distributed Availability Group

I am deploying a SQL Server 2019 Distributed Availability Group. I have created a WSFC at each of my two sites (spanning two servers each). Upon installing SQL Server, it is not clear to me if I ...
0
votes
1answer
34 views

Are Quorums necessary in a SQL Server Distributed Availability Group

I am creating a SQL Server 2016/2019 Distributed Availability Group, which will host 2 AGs (one at one location and another at a different location). Do I need to create a Quorum for each of the 2 ...
1
vote
1answer
67 views

Why sql service is still running after uninstalling failover cluster instance?

The installation of sql server failover cluster instance didn't go well. So I decided to remove whatever was installed and reinstall it again. To to uninstall sql failover cluster instance went ...
1
vote
1answer
65 views

SQL Server Always ON - LOGPOOL_CONSUMER wait and replication issue

I'm facing a strange issue in one of my customers AG. There're 4 instances under this AG. Staring a few days ago, my customer complains about some query (SELECT) timeouts issues. When I faced this ...
-1
votes
1answer
100 views

Remove 2 node Always on setup from SQL Server and failover cluster [duplicate]

We are using 2 node Always-on Availability Group, But Service provider don't support AOAG. So we need to remove one node from Always-on. How can we convert the primary replica to Standalone instance. ...
0
votes
1answer
51 views

SQL Server always-on using WSFC

I have a question about SQL Server Always on using Windows Server Failover Cluster(WSFC). I have 5 SQL Server instances in 2 datacenters using 2 subnets. My data centers: DC1 (192.168.1.0/24), DC2 (...
0
votes
0answers
36 views

SQL Server 2019 Always On Replica Disconnected

We are setting up Always On AGs in SQL Server 2019. The Availability Group will create on both nodes Node1 and Node2 but the database will not restore to the secondary node (Node2) because it is ...
0
votes
1answer
43 views

How can i get AG dashboard values via SQL Query across all supported versions of SQL server

I am trying to ease the monitoring of availability groups across multiple SQL servers. Came across few dmvs which got me the data. But cannot figure out some important columns which i am seeing in ...
0
votes
1answer
97 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 ...

1
2 3 4 5
28