We’re rewarding the question askers & reputations are being recalculated! Read more.

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
1
vote
1answer
202 views

The fulltext filter daemon host (FDHost) process stops abnormally on SQL Alwayson Cluster

We added a new SQL Always-On Cluster (FCI) 2017 and some of the databases needed full text filter service. So we also added that feature to the install. Ever since we did that we have been getting ...
0
votes
1answer
51 views

Does using secondary replica for read operations still required license? [closed]

I wanted to move some of the reporting workload to the secondary replica but the following things stopped me: no writes can be performed (including creating temporary tables); a license is required; ...
1
vote
1answer
44 views

Accessing Administrative Share Using Listener Name

Can a SQL Server AG listener name be used to access an administrative share i.e \\DB-listener\c$\Somefolder? I can RDP using the listener name but can't use the listener name to access the $ ...
3
votes
3answers
259 views

Do I need “New SQL Server Failover Cluster installation” to run Availability groups with manual failover?

I'm trying to set up a test environment here to learn more and apply this on our production environment. I've created and installed the Windows Cluster with CLuster manager. Now I'm going to install ...
6
votes
2answers
345 views

What is the best option for High availability on a data warehouse?

I have a customer who have an existing 1.5Tb data warehouse and are currently planning for a complete refresh of the DW on a new environment. Their infrastructure manager has organised 2 servers with ...
1
vote
0answers
46 views

Availability Group Read Only Routing Not Working for Azure App Service that connects over Hybrid Connection

We have following config of Availability Group On-Premise: server1.domain.com - primary server2.domain.com - sync secondary server3.domain.com - async secondary sql-listener.domain.com - ...
1
vote
1answer
54 views

Which rights to grant for controlling an SQL Server Availability Group?

We are having the following setting: For an ERP Test / Accept SQL Cluster we want to follow the least privilige principle to give the external engineers rights on the SQL server. We are running SQL ...
0
votes
2answers
38 views

Multiple AGs on same Windows Failover cluster the Listeners don't work properly

Here is my case. I have Server1 and Server2, which were installed 4 SQL instances as follows: Server1 Server1\SQL1 Server1\SQL2 Server2 Server2\SQL1 Server2\SQL2 The Server1\SQL1 and ...
2
votes
1answer
35 views

Saved state for SQL Server Always On on Hyper-V

For our SQL DEV/QA environment our system-engineers did setup an Hyper-V enviroment - 3 hosts - 2 VM on each host (1 for DEV an 1 for QA) Patching for the hosts is scheduled once a month but I ...
3
votes
1answer
52 views

Availability Group Read Only Routing Not Working for SQL Logins

We have following config of Availability Group: server1.domain.com - primary server2.domain.com - sync secondary server3.domain.com - async secondary sql-listener.domain.com - availability group ...
0
votes
2answers
81 views

SQL Server - Log file not shrinking in AlwaysOn group

We have three-node AO setup in SQL Server. Primary node, one secondary node in Sync mode and another secondary node in Async mode. Main Database on Primary node, log file-size is 434GB, Used 99.91%. ...
-1
votes
3answers
88 views

SQL Server Always On Availability Group [closed]

I have problem with MS SQL Always On Availability. Suppose the connection between primary and secondary replica is broken. The client inserts data to the primary database (replication cannot be done ...
0
votes
0answers
16 views

Using Policy-Based Management to check backup history for an Availability Group database

I like using Policy-Based Management to do some simple "everything's okay" sanity checks and email me if something goes out of spec. Typically, I validate the time since the last full backup, both to ...
0
votes
1answer
46 views

Always On Availability Group manual failover and OS upgrade considerations [closed]

New to AG - have inherited my first existing system. Have spent quite some time reading MS docs and watching a few training videos but a) concepts seem blurred (terminology similar between different ...
0
votes
0answers
39 views

Cannot failover an availability replica for availability group since it has CLUSTER_TYPE = NONE

Using SQL Server 2017, when I try to manually failover AG to the secondary node by using Failover wizard in SSMS, I got following error Cannot failover an availability replica for availability group ...
2
votes
1answer
46 views

What is the difference between sys.dm_hadr_ tables and sys.availability_groups / sys.availability_replicas?

Browsing around some sys tables, I see: sys.dm_hadr_availability_replica_cluster_nodes.group_name = sys.availability_groups.name and sys.dm_hadr_availability_replica_cluster_nodes....
0
votes
1answer
26 views

SQL Server. Do reads on Read-Only Replica in Availability Group fire Auto Update Statistics on Primary?

We have MS SQL Server 2014 Enterprise Edition with an Availability Group with Readable Secondary. Our application reads data only from Secondary. As far as I know, auto update statistics starts when ...
1
vote
1answer
40 views

Is “Read only routing” the only way to force the connection with ApplicationIntent=ReadOnly to connect secondary replica? [duplicate]

I have no problem with setup "Read-only routing". My point is if we use "Read-only routing". We need to add the "ApplicationIntent=ReadOnly" into our application connection string. That's beyond our ...
0
votes
1answer
32 views

Confusion about HA , LOG backups and availability

So I started to work with HA and I'm on a new job, in a new company that has already HA implemented, but nobody can remember who created or if it's working. 1) Availability Groups are in sync with it'...
2
votes
1answer
70 views

Database level health check did not trigger failover on losing a disk

I'm testing the new database level detection option in 2016 SQL Enterprise SP2 CU7 edition, and it does not seem to be working as expected. We have a 2 node setup, synchronous commit, automatic ...
1
vote
1answer
75 views

Read Scale Availability Groups and Listener

Is it possible to use a listener with a read scale availability group? I have read on some sites you cannot use one but in others that you can. If so, what IP address do you use for it? I have ...
2
votes
0answers
57 views

Distributed Availability Group Endpoint_URL Setup Question

I have two sites: SiteA and SiteB. Both sites are running SQL Server 2017 Enterprise v14.0.3048.4 on Windows 2012. Both sites are linked with a dedicated VPN connection. We have a series of ...
2
votes
1answer
101 views

CNAME alias for AlwaysOn Listener

We are currently experiencing an issue with SQL Server migration. There is a legacy product and we don't want to change connection strings due to various reasons. Thus, we would like to keep existing ...
0
votes
1answer
110 views

All my database on the fail over server showing in “Synchronizing” state

Current Configuration: I have two SQL Servers, which are connected by the failover mechanism, meaning one is primary and one is secondary. I restarted both services on both servers sequentially. On ...
0
votes
1answer
44 views

Is it possible for a node to host multiple cluster in relation to Always On AG

In my example, I have 3 database servers with their own DR servers, own availability group, own clusters. Is it possible to setup another server which can be part of the 3 clusters and be a secondary ...
2
votes
1answer
20 views

Network Maintenance and High Availability Group Prep

We have had a RAID card on one of our switches die, and the replacement had issues which caused my availability groups to failover multiple times between my 2 nodes like a game of tennis and left a ...
0
votes
1answer
54 views

Login permission on Availability group database

We have an availability group database. Just wanted to check on the below statement whether it needs to be run on all replica (By failing over and making it primary)or it can be run on the primary ...
2
votes
2answers
104 views

Availability groups multiple instance, multiple listeners

In my work environment, I have two database machines: DB01 DB02 Each database machine has three SQL Server instances: MSSQLSERVER FBG Central I've managed to set up availability groups with SQL ...
4
votes
1answer
82 views

Checkpoints on secondary replica AlwaysOn AG

Setup 3 Node Alwayson cluster - 1 sync and 1 async secondary replica - SQL Server 2012 Situation We are witnessing PageIOLatches when reading from the asynchronous secondary replica. This is ...
0
votes
2answers
78 views

alwayson read only routing

if i'm change connection string to applicationintent:readonly then i setup read only routing list in my SQL server 2016 , does that mean my application will route all write request to primary and then ...
2
votes
2answers
71 views

Adding a database with Service Broker to an existing Availability Group on a new replica

Server 1 - SQL Server 2016 (Primary in existing AG) Server 2 - SQL Server 2016 (Secondary in existing AG) Server 3 - SQL Server 2016 (Offsite Secondary in existing AG) Server 4 - SQL Server 2017 (New ...
0
votes
2answers
64 views

Error in WSFC Role while applying SQL 2016 CU7 in Multiple SQL instance environment

Kindly advise on following error: Cluster resource 'AG1_NAME' of type 'SQL Server Availability Group' in clustered role 'AG1_NAME' failed Based on the failure policies for the resource and ...
0
votes
1answer
80 views

Does read-only activity on synchronous secondary replica slow down primary replica in Availability Group?

Suppose that we have an Availability Group configuration (SQL Server 2017) where primary and synchronous secondary do not share any resources (each replica have dedicated CPU, memory, disk, etc.) ...
2
votes
1answer
63 views

SQL Server takes an hour to fail over to secondary node

I am at a new job, we have a 2008 R2 (SP1) WSFC which hosts SQL Server 2008 FCI. Each node has it's own storage, nodes are 32 core with 32 GB memory (don't ask me why it is configured this way). ...
1
vote
0answers
27 views

When does the quarantinethreshold counter reset in WSFC cluster?

An outage that occurred on our SQL availability group this morning caused us to look into the quarantine settings on WSFC - something we never needed to configure. Now there seems to only be two ...
0
votes
0answers
15 views

Availability Group Replication issues: Distributor (named instance) and Publisher (default instance)

Following the documentation provided (Configure replication with availability groups - SQL Server Always On | Microsoft Docs) I set up an AG-based Distributor (REPLAG) and an AG-based Publisher (PUBAG)...
0
votes
0answers
57 views

SQL AlwaysOn Dashboard Not Showing Green Circles

I have a SQL server 2017 with SSMS 18.1 and SAO dashboard shows gray circles instead of the green check marks. It does not matter if it is secondary or primary it always shows grey circles. The server ...
2
votes
1answer
91 views

SQL server AlwaysOn database not automatically seeding, cannot find logs with reason

I've added a database to an availability group that already has a few databases, all of which seeded and syncing fine to the secondary. This last one gets added to the availability group, it would ...
0
votes
0answers
28 views

DBCC UPDATEUSAGE versus data inaccuracies [duplicate]

SQL Server 2014 SP2 with Availability groups 3 Node Windows Cluster for AOAG (2 Sync & 1 Async Replicas) NOTE : Databases are with FileStream Enabled Recently we applied Encrypting File System (...
1
vote
1answer
33 views

Legacy data migration to Always on Availability group database

In our application there is a data conversion process that brings all the legacy data to the production database. Since our database is on availability group and the migration might bring 100GB + ...
1
vote
0answers
309 views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
1
vote
1answer
42 views

Failover Availability Group from linked Server

I am hoping you can all help me in what feels like a really simple problem, but one I am struggling to find a solution for. We are running SQL Server Standard 2016 and utilize availability groups ...
4
votes
2answers
160 views

Why is our query suddenly returning rows it should not (using READPAST and UPDLOCK options)?

We have a job table that looks like this CREATE TABLE [dbo].[Clearing]( [Skey] [decimal](19, 0) IDENTITY(1,1) NOT NULL, [BsAcctId] [int] NULL, [Status] [varchar](20) NULL, CONSTRAINT ...
0
votes
2answers
265 views

Problems with Listener in AlwaysOn AG in AWS

I have a 2 node AlwaysOn AG cluster with a single database being replicated between the 2 nodes. Windows Failover Clustering Services are installed on each node. The AG is configured to allow ...
1
vote
2answers
101 views

Multi-site Failover Cluster Instance for HA and DR to alwaysON Availability Groups [closed]

In my company we have chosen to implement Multi-site SQL Server Failover cluster. Basically Data center A has 2 nodes (Active/Passive) and Data Center B geographically located acts as the DR. I ...
1
vote
1answer
41 views

Sync Server Objects when having two or more Availability Groups

Lets imagine that i have two servers/nodes with TWO availability groups Group01 and Group02. I will need to ensure that the server objects are all the time recreated over the secondary replica. If i ...
2
votes
1answer
21 views

How many nodes can you install SSRS on when using basic availability groups?

I have migrated a SQL Enterprise standalone SSRS installation to a new SQL Standard 2 node Basic AG recently. I got the expected "scale-out-deployment is not supported error", and I resolved that by ...
1
vote
0answers
280 views

SQL alwayson manual Failover Cluster failed because a duplicate IP address detected

When I manually tried to make a failover I got the following errors: "SQL always on Cluster IP address resource listener cannot be brought online because a duplicate IP address was detected on the ...
1
vote
0answers
11 views

cent os 7 alwayson primary is in resolving state and not going to secondary

I have configured AlwaysOn in external mode between two CentOS 7 VMs. When manual failover happens, primary goes to resolving state. It never turns to secondary and secondary is always in secondary ...
0
votes
0answers
16 views

SQL Server read-replica hosted on AWS with ephemeral storage

I have a temporary need (during transition from on-prem to AWS) to provide a high-performance SQL server instance for analytics. I would like to purchase two SQL server enterprise instances. One ...