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
3answers
38 views

SQL Server Always On Availability Group

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
1answer
39 views

Read Only Routing Does Not Work After Failover in SQL Server 2016 Always On

I have 2 nodes in an Always On Cluster - Node A and Node B I have configured read only routing. When Node A is Primary and node B is secondary , the read only routing works and read only connections ...
0
votes
0answers
13 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
20 views

Always On Availability Group manual failover and OS upgrade considerations

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
16 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
24 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
20 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
28 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
30 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
54 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
57 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
34 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
33 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
36 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
19 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
39 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 ...
1
vote
1answer
73 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
67 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
61 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
57 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
50 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
59 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
59 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
14 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
12 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
51 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
52 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
27 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
29 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
98 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
24 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
151 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
81 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
58 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
35 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
17 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
106 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
9 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
10 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 ...
1
vote
1answer
74 views

LOG backup Always ON using Ola Hallengren database backup script does not carry out a backup

I am trying to run a LOG backup on the primary node of an Always ON SQL Server 2012 environment. The secondary server is only used for replication. no read or other access permitted. (licensing of ...
1
vote
1answer
44 views

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers, SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below: select distinct rcs.database_name, ar....
0
votes
0answers
27 views

How to add a Database on existing Distributed Always on? [duplicate]

I have added a database on the existing Distributed Always on between server A and B which are prod server. Now I need to replicate same DB on server C and D which are DR server.
0
votes
1answer
19 views

reportserver will not join basic availabiltiy group

I am running into a strange situation that I have not been able to resolve.  I have a 2 node Basic AG running sql server 2016 standard.  I am trying to add the reportserver DB to an AG, but it keeps ...
1
vote
1answer
45 views

Automatic Failover on SQL Server Always On Availability Groups is not triggered when primary replica becomes offline

I have set up a 2-node Always On Availability Group. Both replicas are in synchronous mode with automatic failover. If I perform a manual failover, everything works as expected: Primary and Secondary ...
4
votes
1answer
879 views

Messages about parallel redo

Parallel redo is shutdown for database '' with worker pool size [2]. Parallel redo is started for database '' with worker pool size [2]. Starting up database '' I see this on a client PC a lot in ...
1
vote
1answer
37 views

What is the Always On Sync sync frequency?

On an Always On Availability group, I understand an async secondary replica asks the primary for the blocks to be shipped. However, I would like to know how frequent is this task (to know the possible ...
1
vote
1answer
35 views

How To Prevent Live Servers From Detecting a Forced Failover?

We are using an AlwaysOn Availability Group in SQL 2017 on Windows Server 2016 which consists of two servers on our primary site and one DR server on a remote site. We recently did an internal IT DR ...
1
vote
1answer
29 views

Is there any special configuration for SQL Server implementing Routing List in a heterogeneous enviroment (Client and Server in different domains)?

I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes....
0
votes
0answers
34 views

SQL Server LDF is is keep growing on secondary Always on

I have configured ALways-On (Async mode) on SQL server 2017, recently LDF file has been growing on secondary (80 GB), but on the primary database it is less than 50 MB, also I have set up full back ...
4
votes
1answer
39 views

Add replica from node 1 can't find node 2 while installing an Always ON AG lab on virtual machines

I am trying to set up an Always ON availability group lab on virtual machines, with Windows Server 2016 and MS SQL Server 2017. While creating a new Availability Group on node 1 by the wizard, I ...