All Questions
Tagged with sql-server availability-groups
1,263
questions
0
votes
0
answers
21
views
Manual Failover of SQL Server Distributed Availability Group
Is anyone able to kindly shed some light on an issue for me please? I have two Distributed Availability Group environments, one is SQL 2019 and the other is SQL 2022. The SQL 2019 environment is fine, ...
- 341
0
votes
0
answers
28
views
Process to remove High availability and Break the cluster
We have a 4 node High availability group. We now will have to make the primary a standalone server and remove all the replicas and break the cluster.
Before we attempt this on production below is what ...
- 1,061
0
votes
1
answer
39
views
DLL switch over issue while AOAG automatic failover
We have configured AOAG in our environment, but when performing automatic failover from one node to another, the DLL is not enabled automatically in the second node. We are manually enabling the DLL ...
- 1
0
votes
1
answer
78
views
Failed to open the explicit specified database
When our application tries to connect to the Availability Group Database, we get the following error message on the primary replica:
Login failed for user 'xxx'. Reason: Failed to open the explicitly ...
- 341
1
vote
1
answer
76
views
Deny access to Sql Server replica when it becomes primary
TL;DR
How to allow read-only access to some users on one replica (in an Sql Server availability group), only when the replica is secondary, and deny it when it becomes primary?
Explanation
I'm ...
- 121
0
votes
0
answers
21
views
Is there a way to prove whether a connection used the MultiSubnetFailover argument? [duplicate]
I know that consulting sys.dm_exec_connections can show whether a connection is using an AOAG listener or was made directly to the instance. And I know that if a connection is successful that it was ...
- 21
1
vote
1
answer
49
views
How to configure listener when using read scale AG?
I have a cluster-less AG (read scale AG) without a listener.
Our network admin has set DNS entry to point to primary node. All applications use that DNS name for database connections.
Post failover ...
- 3,476
0
votes
1
answer
47
views
Azure MS SQL Always On Availibity Group Setup Issue
I have 2 VMs on azure where MS SQL server is configured with always on high availability, one VM is acting as primary and other one is secondary. On top of that, there is domain controller VM which is ...
0
votes
1
answer
48
views
Does availability group listener runs on both SQL Server nodes or does it run on a separate machine
Lets say I am setting up AlwaysOn Availability Groups and following are the nodes:
Primary
192.168.1.10
Secondary
192.168.1.11
I try to create a DNS entry for availability group listener called ...
- 451
0
votes
0
answers
28
views
Configure multiple instances on a SQL Availability group cluster
I need some guidance please.
My Distributed AG configuration is to be with:
Two SQL 2022 named instances each with its own AG and AG listener on the Primary Cluster
hence two DAGs on the one cluster
...
- 341
-3
votes
2
answers
79
views
2x SQL Server 2019 in AlwayOn group - how to remove transaction log [duplicate]
We have a problem with our Microsoft SQL Server 2019. We have 2 servers in an Always On group with one database. Problem is the actual (real) database size which is about 1 GB, but it takes up around ...
- 1
2
votes
1
answer
39
views
Can we take a copy-only backup for filegroups on the SQL Server from a secondary HA replica?
I am getting the below error while executing the script for taking filegroup backups from a secondary replica.
Msg 3059, Level 16, State 1, Line 18
This BACKUP or RESTORE command is not supported on ...
user24604008
0
votes
1
answer
78
views
Availability group failover-tempdb
Does anyone know if SQL AG will initiate automatic failover to secondary if tempdb is full in primary ? I believe Database level health detection is only for user database in AG
- 47
0
votes
0
answers
29
views
Connect to a Private SQL Always On Availability group listener with Azure App
We have a fairly standard Azure Webapp - connecting via public IP to a database server which is a VM hosted in Azure. NSG rules etc limit the traffic between the two. The VM hosting the database is ...
- 31
0
votes
1
answer
53
views
Preferred seconday backup in AG - what about the primary ? Shows no backups taken
I did setup the Ola Scripts sticking to https://www.brentozar.com/archive/2015/06/how-to-configure-alwayson-ag-backups-with-ola-hallengrens-scripts/
Options are:
@Databases = 'USER_DATABASES',
@...
- 1