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
10 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
29 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
18 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
49 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
33 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
57 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
36 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
39 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
45 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
21 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
38 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
64 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
173 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
37 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
47 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
74 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 ...
1
vote
1answer
43 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
40 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
66 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
61 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
58 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
22 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
35 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
33 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
44 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
31 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
45 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
60 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
69 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
48 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
27 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
40 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
81 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 ...
0
votes
1answer
38 views

Availability Groups - Add new subnet

I have a two node Availability Group system which hosts several AvailabilityGroups. Each AG has it's own listener. The system was set up in an IP-subnet with very few free addresses left. How can i ...
0
votes
1answer
27 views

SSRS second entry never shows up in scale out deployment screen

I am trying to setup two SSRS servers in a scale-out deployment that use a Always-On availability group for the database. The AG is setup and working. I have both SSRS servers using the AG listener ...
0
votes
1answer
52 views

SQL Server data drive (.mdf files) running out of space

We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space. A few weeks ago DB files were shrunk to temporarily ...
0
votes
0answers
36 views

MSSQL plan guide usage on AAG replica

I'm trying to use plan guide on read only replica. I read some articles ( for instance this one ) and concluded that this is impossible. But then tried to perform some tests and got pretty unclear ...
0
votes
1answer
31 views

Turning off Secondary Replica in Always on availability group for maintenance

We are planning to turn off the secondary synchronous replica in our always on availability group for few hours for maintenance . Once we are done with the maintenance then we will need to failover ...
0
votes
1answer
35 views

Using custom port for listener

I have a requirement of migrating a cluster instance to an AlwaysON instance without changing the connection string from the application. My Existing connection string looks like- Server1\Instance1:...
0
votes
2answers
117 views

Testing WSFC failover puts secondary replica in RESOLVING mode

I have 2 locations and each has its own WSFC. Cluster 1: WSFC,Datacenter1, Node1, Node2. Listener1 Cluster 2: WSFC, Datacenter2, Node3, Node4. Listener2 Created an Availability group as EXTERNAL ...
0
votes
1answer
53 views

How to configure Always ON High Availability on this infrastructure?

I have SQL 2017 Enterprise Edition What would be the best way to set up High Availability in the below infrastructure? Datacenter 1 WSFC and FCI: Node1, Node 2, Shared Storage Datacenter 2 WSFC and ...
0
votes
0answers
44 views

Always Encrypted issue with Always On after failover

I'm running on a SQL Server 2017 Always On 14.0.3381.3 DB and I'm testing using Always Encrypted. I'm not sure if this is a SQL Server issue or a .NET issue. What happens is when I open up my .NET ...
1
vote
1answer
51 views

LISTENER_IP = ALL not working

I try to create an endpoint specifying to listen on any IP: CREATE ENDPOINT [Hadr_endpoint] AS TCP ( LISTENER_PORT = 5022, LISTENER_IP = ALL ) FOR DATABASE_MIRRORING ( ...
0
votes
2answers
67 views

Solution for syncing a database between two server and secondary can be used for all DML operation

I need a solution to synchronize a database (SQL Server 2016 Enterprise) between two servers, and I would be able to connect my secondary application to the secondary database which is getting ...
0
votes
1answer
89 views

Can't remove "synchronizing/suspect" database after removed from availability group Sql Server 2019 Enterprise

I've removed a db from a synchronous availability group.The db shows "synchronizing/suspect" as it should on the secondary. I'm trying to remove this database cannot. I have tried: DROP ...
1
vote
0answers
53 views

Windows Failover Cluster/Availability Groups - Issues because all servers of one site where unreachable

we had some issues because of maintenance and hope someone can explain what happened. Our cluster looks like this: Site A: Node A1 (Quorum vote) Node A2 (Quorum vote) Node A3 (Quorum vote) Node A4 (...
1
vote
1answer
108 views

Estimated recovery time and REDO queue size related to DB up time

Can someone help me figure out if my understanding is correct on the below: On the AG Dashboard for my readable secondary replica I see: Estimated recovery time (secs) - 4598 REDO queue - almost 24 ...

1
2 3 4 5
27