Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

-1
votes
0answers
30 views

No matching network interface found for resource 'Cluster IP Address' IP address 'xx.xxx.245.140' (return code was '5035')

In a cluster of one node at each site, the cluster is showing this warning and error as Cluster resource 'Cluster IP Address' of type 'IP Address' in clustered role 'Cluster Group' failed. ...
0
votes
1answer
33 views

SQL AlwaysON. keeping Agent Job in sync, but with same JobID?

Is there a way to specify Job ID when creating a job? Or is there a way to update the Job ID of a specific Agent Job that already exists? I have a software from a vendor that uses the Job ID to ...
0
votes
0answers
36 views

Open transaction preventing log reuse?

I have a SQL servers in an availability group, set as synchronous commit. Due to this setup, log backups only reclaim log space when a backup of the secondary has been processed. I noticed my log ...
0
votes
0answers
32 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
5
votes
1answer
72 views

Performance gain with MultiSubnetFailover for single subnet

On BOL I read following about MultiSubnetFailover=True: The MultiSubnetFailover connection option should be set to True even if the availability group only spans a single subnet. This allows you to ...
3
votes
3answers
54 views

Why is the Read-Only Routing not functioning in this Availability Group?

First off, my apologies if this has already been answered elsewhere. I have not been able to find any articles or threads describing my exact situation, but no one's Google-fu is perfect. With that ...
0
votes
1answer
26 views

Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode

I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
0
votes
1answer
15 views

Difference between Client Access Name in SQL server Fail over Cluster and Always on availability group

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance ...
-1
votes
0answers
20 views

Who is responsible for Windows clustering DBA or Sysadmin [closed]

Our SQL server runs on SQL Clustering now management has decided to move to Always on availability group. I would like to start from scratch but needed clarification regarding who is responsible to ...
0
votes
0answers
46 views

Application Failed to Connect after Failover [on hold]

We have 2 nodes Alwayson Availability group , SQLServer 2016 Enterprise edition. It was working fine until recently if failover occurred most of the time the application fail to connect to the ...
1
vote
1answer
37 views

is there a way (clean or unclean) to eliminate a filestream data file on a production SQL Server database?

Is there a way (clean or unclean) to eliminate a filestream data file on a production database? I forced a garbage collection on an empty filestream : sp_filestream_force_garbage_collection @dbname =...
0
votes
0answers
37 views

Ola Hallengren backup AG and directory path

I have please questions about Ola Hallengren backup backups on AG - If I have more than 1AG , the backup setting in case primary or secondary is based on first group ? directory paths - is there ...
1
vote
0answers
28 views

Adding Databases to Availability Group

I'm attempting to add databases to an existing availability group using automated seeding but I randomly receive this error: "Seeding Check Message Timeout". I'm pulling this error message from sys....
0
votes
1answer
21 views

Don't show local databases in SQL Always-On AG

We're installing a SQL Server Always On AG solution(SQL Server 2016) in a test-enviroment at our organisation. When testing the features we notice that all databases from a node are listed when we ...
0
votes
0answers
22 views

Availability Group being PARTIALLY_HEALTHY

I'm having a strange issue with a SQL server hosting 11 Availabilty Groups. All those groups have 1 or 2 databases in it and they are synchronous commit with the automatic failover. I noticed ...
0
votes
0answers
13 views

Moving the FileStream Data Drive to New Location and enabling EFS

Can any of the MS FileStream experts help me on below: I do have the 5 App DBs with FileStream enabled. Current the size of **C: for FileStream Blob data is 5 TB** All the DBs have below drive ...
0
votes
0answers
16 views

Availability Group Not Synchronizing [duplicate]

We have a two node Availability Group with 2 AGs. Something happening to the primary, node1 and it failed over the AGs to the secondary, node2. Node 2 is now the primary. All of the dbs in AG2 failed ...
1
vote
0answers
57 views

Configure Always On for publisher

We have a pull transaction replication.Publisher runs MSSQL 2016. Distributer runs on separate server with MSSQL 2016. Is it possible to define Always On over publisher and another new server, so ...
6
votes
1answer
199 views

Single Server (Replica) Availability Group

First time caller, long time listener. I have a situation where I need to stand up a single server Availability Group for around 2 months (i.e. move DBs to a new server, rebuild the current server, ...
2
votes
1answer
36 views

CPU cost in SQL Availability Group for synchronous and asynchronous DB's

We are looking at setting up a new SQL Always On Availability Group environment for SQL Server. We are wondering if there's a difference in CPU usage of a synchronous or an asynchronous node? Also ...
1
vote
2answers
62 views

Cluster Configuration

I’m looking at some of the SQL servers in a (new to me) SQL estate. The servers are configured for AOAGs; there are two nodes, both are part of the WSFC. However, if I look at the SQL Server advanced ...
0
votes
1answer
14 views

WildCard to Skip Synchronized DB

I am running a security RAG on reporting server that updates our security and put database to read_only mode. I am using wildcard to skip system and some other databases, but what can I use to skip ...
0
votes
0answers
16 views

Availability Group Read-Only Routing to Synchronous vs Asynchronous Replicas

I'm looking for some insight into the logic behind Read-Only routing when it comes to synchronous vs asynchronous replicas in a single Availability Group for SQL Server. My understanding is that in ...
2
votes
1answer
32 views

availability groups - checking for primary server - cannot call a procedure with parameters

In my servers that are involved in alwayson availability groups if there are jobs running, inside the jobs I always test whether the current server is the primary in the availability group. So the ...
0
votes
1answer
42 views

Redo thread pending work

I've got a real tricky one here, there so much conflicting evidence it's difficult to write up the question! Here goes.. I've got a 2 node AOAG: node 1 is currently the secondary replica (but I ...
1
vote
1answer
35 views

Failover Cluster Owners

In Windows Server Failover Cluster Manager I can see "possible owners" under "Other Resource" and also under "Server Name". I have a 3 node AlwaysOn Availability Group with 2 servers in synchronous ...
1
vote
1answer
43 views

Disabling IPV6 on Always on availability group

In our environment we only have one network adapters for the Replicas and IPV4 is being used. By default the IPV6 is also enabled. My question is will there be any problems if I unchecked IPV6 from ...
1
vote
1answer
31 views

Syncing Server Objects across AG nodes

This is my first question, hope I do it right! I am working on creating a process that will sync server objects between our AG nodes. We are using SQL Server 2016 with 4 nodes. Two nodes in one data ...
6
votes
1answer
203 views

DBCC CHECKDB on Always On databases

Do we really need to run DBCC checkdb on a database configured with Always On synchronous updates? I believe the automatic page repair mechanism should identify the corruption and repair it ...
1
vote
0answers
120 views

dbcc failing with Cannot continue the execution because… alwayson having a change of state event for each db

I got a job DatabaseIntegrityCheck - USER_DATABASES, failing with the following error: Date and time: 2018-10-29 02:34:13 Command: DBCC CHECKDB ([one of my databases]) WITH NO_INFOMSGS, ...
1
vote
1answer
40 views

Can two primary AlwaysOn servers be each other's secondary--for completely seperate sets of databases?

Can two primary AlwaysOn servers be each other's secondary? We have a situation where our primary disaster recovery site it also a valid hospital satellite (SQLB) to our main campus hospital (SQLA) ...
0
votes
0answers
39 views

Adding database to availability group on second instance

I'm trying to add a database to an availability group and the secondary replica is on a second instance on the failover server. The database name already exists in the default instance but not the ...
1
vote
1answer
29 views

AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC?

Please help to to research the possibility of below: We have availability group that consists of two replicas: replica 1: SQL Server 2017 on Windows Server 2016 replica 2: SQL Server 2017 on ...
0
votes
0answers
17 views

AlwaysOn DB login cannot connect to the secondary server [duplicate]

I have a DB in AlwaysOn, when I fail over it to the secondary server The user \ login in the application shows an error of authentication and cannot connect to DB. Suggestions?
0
votes
1answer
29 views

Availability groups

I'm trying to learn and implement availability groups clustering in Azure. How secondary replica knows that the primary replica is down? In FCI, heartbeat links are there right? like that what we have ...
0
votes
0answers
41 views

SQL Server AlwaysOn backup transaction log on secondary, error appear in log

I have a SQL Server 2016 AlwaysOn with two nodes. I set the backup preferences as follow: Primary, node1 50%, node2 50%. I configure a full backup job (custom script verifying sys....
15
votes
2answers
409 views

SQL Server 2017 with 500 databases - Frequent AG disconnects since CU9

Hi everyone and thanks in advance for your help. We are experiencing challenges with SQL Server 2017 Availability Groups. Background Company is a retail B2B back-end software. About 500 single ...
1
vote
1answer
103 views

Availability groups and Linked Servers

I have inherited an Availability Group and have found that a linked server was set up between the two nodes of the availability group. It is using sa for authentication unfortunately. Simultaneously, ...
0
votes
1answer
34 views

IP address to use with FCI, Always On AG and Always On (AG) FCI

My understanding is that HA can be achieved using either of the below and my concern was which IP address should client applications use when connecting to SQL Server: Failover Clustering: For this ...
0
votes
1answer
37 views

Automatic failover (Clustering/Always On AG)

Let's says we have 2 nodes (N1, N2) clustered (say C1) on-site. And an Always On AG is configured between this cluster C1 and a new SQL server instance N3 (N3 is off-site). Now, if there is a problem ...
2
votes
1answer
75 views

Always On Setup - OBJECTSTORE_SERVICE_BROKER Memory clerk eating all the memory

We have an Always On setup where in we have two secondary replicas to our primary replica. One of the secondaries is placed in the same datacenter as the primary and the other one is placed at a ...
0
votes
1answer
149 views

Always ON - What is the difference between the virtual cluster name and Listener

In clustering you specify DNS name/IP address of cluster that is then used by all applications. In case of failover, the same DNS name/IP address will point to the appropriate database server. In ...
-1
votes
1answer
243 views

Always On Failover Clustering vs Always On Availability Groups

I have some concerns over my understanding of SQL Server Always On. Kindly can you correct me (conceptually) where needed: Always On Clustering and Always On Availability Groups are 2 separate ...
1
vote
0answers
77 views

Error: CImageHelper::Init () Failed Load of symbol file with path

Using SQL server 2017 (14.0.3029.16) with Always On High Availability environment. Getting error: CImageHelper::Init () Failed load of symbol file with path = C:\Program Files\Microsoft SQL ...
1
vote
1answer
18 views

Is a @CATALOG argument required in linked server to connect to READ-ONLY secondary?

I have 1 primary and two secondaries. Node 3 is READ-ONLY. I created a linked server as follows (as described in Microsoft Docs): EXEC sp_addlinkedserver @server=N'Node3', @srvproduct=N'', @...
0
votes
0answers
38 views

Always ON Connection string issue

In the environment I am currently working, the connection string which is being used is wrong ( AG_LISTENER_Name\InstanceName). This is something we need to correct in all apps that is configured. ...
0
votes
1answer
37 views

Enabling TDE on SQL Server AOAG 2014 Databases - Guidance

I am completely new to Transparent Data encryption and please help me on below questions related to enabling the TDE on existing PRODUCTION Databases. Primary Question: What are the things which I ...
2
votes
2answers
43 views

SQL Server AAGs/Possible Endpoint contention/Synchronous replication to WAN Secondary

In the interest of saving some SQL Server licensing moolah ($$$), we’re going down the path of extreme consolidation. We’re trying to shoehorn as many databases as possible into a SQL Server 2016 ...
0
votes
1answer
31 views

Excluding Read only Log backups using ola-hallengren script

I know that Full backups are excluded from readable secondaries, but how do I exclude log backups from read-only secondaries? The is_read_only column in sys.databases does not get set on ...
1
vote
0answers
31 views

How to find/calculate time taken for synchronization in SQL Always on AG?

I have an SQL Always On Availability Group (AG) with 4 Servers (Replica). I'm going to add a new database (about 200GB) in the AG. I want to measure the time taken for the dB synchronization (...