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.

learn more… | top users | synonyms (1)

0
votes
0answers
3 views

AlwaysOn Failover - SQL Server 2014

I have two SQL Servers 2014 in AlwaysOn AG setup (OS - WSFC2012R2) with secondary acting as a synchronous replica. I'm facing an issue in the role switchover on daily basis. Every day morning around ...
0
votes
0answers
7 views

How to maintain Schema changes with two Publisher into one Subscriber?

AlwaysOn Availability Groups configured with Replication Subscribers with two publisher on sql server 2014.its running successfully.... Problem - When I changes on schema at publisher 1 then I take ...
1
vote
1answer
22 views

Log File Full — Database is in AlwaysOn

Database log file is 99% used.and sys.databases says LOG_BACKUP.Will manual log backup affect the AlwaysOn ? and like log shipping will AlwaysOn have log backup jobs ? Shrinking fails because of ...
0
votes
0answers
25 views

SQL SERVER - “ApplicationIntent=ReadOnly”Listener redirect to fully qualified domain name

Hi all my DBA has setup a primary myNodeA and secondary node myNodeB and I'm trying to access the secondary node using "ApplicationIntent=ReadOnly" in JDBC connection string. The problem we are ...
0
votes
0answers
18 views

In-memory file group and log are growing huge and fast

We have a DB in stress environment: SQL Server 2014 (SP1-CU3) + Always ON The whole db is around 850GB, but in some point something happens and in memory FG is growing to 250GB and a log to 450GB (...
1
vote
1answer
19 views

SQL Server 2014 (12.0.4439.1) to SP2 (12.5000) service start failure

In what seems to be eerily familiar to the oh-so-famous SSISDB SP1 fiasco, I've hit a snag while upgrading our DEV server to SQL 2014 SP2. The base version was SP1+CU5 (12.0.4439.1). We have SSISDB ...
0
votes
1answer
31 views

AlwaysON AG synchronous commit mode disconnected transaction log effect and mitigation

I have an AlwaysON AG with one primary and one secondary replica in synchronous commit mode. The databases in the AG all have autogrowth disabled (standard policy within organisation). There is ...
1
vote
1answer
55 views

Replication Subscribers and AlwaysOn Availability Groups (SQL Server)

I have AlwaysOn Availability Groups configured with Replication Subscribers, and is currently running successfully with one publisher using the command below. -- commands to execute at the publisher,...
0
votes
0answers
14 views

AlwaysOn unusual behavior: sqlagent job rurns 2ndary while pointing to Primary?

We have SQL Server 2012 with AlwaysOn along with a bi-weekly scheduled sql server agent job that seems to also runs on the SECONDARY while pointing the PRIMARY's tables inserting the records twice. ...
0
votes
1answer
17 views

ACCESS_METHODS_DATASET_PARENT Problem

We had an AlwaysOn Async replica we had some problems so we deleted the availability group After that the database and CPU seem to work abnormally It's very slow and we have waittype = LATCH_EX , ...
0
votes
0answers
12 views

AlwaysOn DR/BCP Test Plan

I have setup new environment of AlwaysON on SQL Server 2014 for application.Now I have to test the DR/BCP failover.May I know the process to be followed and what all steps do I need to take care while ...
0
votes
1answer
27 views

Persisting connections over AG failover

I see that: ‘When an availability group failover occurs, existing persistent connections to the availability group are terminated and the client must establish a new connection in order to continue ...
1
vote
2answers
46 views

SQL Server Always On or Mirroring & Log Shipping

We have two data centers with a 2 ms ping time between them connected by a site to site VPN. In the primary data center we have 2 servers, in the secondary data center we have a single database server....
0
votes
1answer
25 views

Rebuild Windows cluster for Alwayson.

I am setting up Alwayson,somehow my cluster is gone ( get-clusternode shows down,down,down and Joining). SQL Server is working fine. What Should I do? Create new cluster or build new server? Any ...
1
vote
0answers
23 views

Connection timeout via AlwaysOn Listener IP on local computer

I have AlwaysOn availability group and it has one Listener IP. I can connect this instance using Listener name but, cannot connect using Listener IP from my local computer. It returns following error ...
3
votes
1answer
46 views

Any disadvantage to automatically changing FULL backup on AlwaysON Secondary to COPY_ONLY?

I've been playing around with Ola's maintenance scripts recently, and they are absolutely great. However, I was considering one scenario and was surprised when I found it wasn't catered for. Maybe I'm ...
0
votes
1answer
55 views

AG (SQLServer 2014) - Suspend Data Movement

I have a primary replica and one secondary. Multiple availability databases. Secondary replica is located at DR site. For DR testing, is it possible to failover to the secondary replica, make (test) ...
0
votes
0answers
35 views

What is the VERSIONING_COMMITTING wait type in SQL Server 2012?

I have a fairly large SQL Server 2012 database in an availability group that experienced performance problems for about an hour, with the bulk of the wait in HADR_SYNC_COMMIT (waiting for synchronous ...
0
votes
2answers
30 views

Always On Listener Behavior - DBs removed from group

We have multiple multi-site always on failover cluster instances in our env. We have an enforced internet outage being imposed on us and at the time the link between the data centers will be down for ...
1
vote
1answer
48 views

SQL Server 2016 Standard AlwaysOn group

In my SQL Server, I can’t see that options (Basic Availability Group, Database level health Detection, Per DatabaseDTC Suport) at New Availability Group – Specifiyname. I just see to write the [...
0
votes
0answers
21 views

Combining SQL Failover cluster with availability groups and SAN replication

We are looking at implementing the following Windows cluster containing 4 node FCI (2 nodes per data centre) with SAN replication - our current setup. manual failover (storage first then SQL resource)...
1
vote
0answers
41 views

SQL Server 2012 AvailabilityGroups - Preferred Backup Replica

I currently have a 2 node SQL Server 2012 HA Availability Group setup. Currently we have a number of SharePoint databases that exist in this availability group. I'm attempting to ensure our backups ...
0
votes
1answer
43 views

Automatic recovery on a 3 node AlwaysOn Multisite Cluster?

We are looking to build a 3-node AlwaysOn Windows 2012 R2 failover cluster with 2 nodes in our primary datacenter for HA, and a 3rd node replica in our DR datacenter for reporting. Given this is a ...
3
votes
1answer
50 views

How to Load Balance Availability Group

I have 2 Servers under SQL Server Cluster (Server 1, Server 2) 2 Databases configured with Availability Group (Database 1, Database 2) Server 1: Database 1 PRIMARY REPLICA Database 2 PRIMARY ...
0
votes
1answer
60 views

Failed to create, join or add replica to availability group in SQL Server 2014

I have a 2 node FCI and a standalone SQL Server installation on a non FCI node. I have been automating the configuration/installation of FCIs, AGs, and DB Replicas which has worked fine up to now in ...
1
vote
1answer
35 views

Scheduling backup jobs for an Availability Group

In a MS SQL Server 2014 AlwaysOn AG setup, I would like to schedule backup jobs for a given availability group. The ultimate goal is to have the regular backups run on the synchronized secondary and, ...
1
vote
1answer
38 views

Recommended ways to upgrade AlwaysOn AG from 2014 to 2016

What is the recommended process of upgrading Availability Groups with one Sync Replica from SQL 2014 to 2016? My understanding is that in-place upgrades are not really liked among database ...
3
votes
0answers
47 views

How to manage primary key value while multiple secondary server sync with primary server?

we have three secondary database server in different cities and one primary server. my question is i want asynchronous transaction commit to all three database but primary key data conflict occur ...
1
vote
1answer
37 views

Expanding AlwaysOn Availability Groups with Replication Subscribers

I have query regarding "AlwaysOn Availability Groups with Replication Subscribers"... Can I add multiple publishers to a subscriber(which is part of availability group as a primary server)? In which ...
1
vote
0answers
24 views

availability-groups

I was in the process of configuring aag on two new 2014 Enterprise servers. The configuration going good and the cluster, the nodes, the listener, the fileshare witness are online. Everything seems ...
16
votes
5answers
443 views

From the DMVs, can you tell if a connection used ApplicationIntent=ReadOnly?

I have an Always On Availability Group set up, and I want to make sure my users are using ApplicationIntent=ReadOnly in their connection strings. From the SQL Server via DMVs (or Extended Events or ...
0
votes
0answers
23 views

SQL Server 2014 Availability Group Listener only visible to primary node of AG

I'm having some trouble configuring the Availability Group Listener for SQL Server. Here's my current setup: I have one server, lets say server DC, which acts as the domain controller for AD DS with ...
1
vote
0answers
34 views

SQL Replication Monitor does NOT show publication properties - Transactional Replication

The setup I have is as follows: a) Version SQL Server 2014 SP1 CU6. b) publication is on a separate availability group [AG1] and subscriber is part of another AG [AG2]. c) Distribution is ...
1
vote
1answer
41 views

How to check programmatically which replica I'm connected to

I have an AlwaysOn Availability Group on MS-SQLServer (2 replicas) and a C# application which sends queries to the Availability Group Listener. How can I check which replica is responding my queries? ...
0
votes
1answer
37 views

AlwaysOn Shared network location change requrest

We have successfully setup the Alwayson with different subnets and it was working fine. But unfortunately the existing NAS storage had a problem. Now our storage team provide new storage IP. We need ...
2
votes
1answer
78 views

Microsoft SQL Server AG Synchronous Mirroring is not synchronous

We were upgrading to SQL Server 2012 and decided we wanted to divorce ourselves from replication we were using for Reporting services on Node 2. AG and mirroring looked like a good solution -- and we ...
11
votes
1answer
165 views

Will running a large query on a secondary database in an availability group affect transaction performance in the primary database?

I need to provide real-time, or almost real-time, data for SSRS and Tableau reporting. I don't want the production OLTP system to be negatively impacted by long running queries. Will running a large ...
0
votes
1answer
48 views

SQL Server 2014 - AlwaysOn HA - Always Synchronizing

I have a Windows Server 2012 R2 cluster with SQL Server 2014 configured in a HA configuration. The secondary databases always say Synchronizing when the data movement is happening. Is this normal? ...
2
votes
1answer
177 views

By Mistake Deleted AlwaysOn Availability Database from live Production Server

Today by mistake deleted The AlwaysOn Availability Database from live server. Let I am explaining the Details. In AlwaysON Availability Groups, there is 2 Availability Replica. That is Primary ...
-3
votes
1answer
46 views

Upgraded to SQL Server 2012 and sql server agent scheduled jobs run twice

We recently upgraded from 2008 to 2012 and with one of our applications running on a ACTIVE & PASSIVE server (Always On) it has been running twice at the exact same time. We verified it wasnt ...
1
vote
0answers
55 views

Single volume for five Filestream databases

We are going ahead with PROD server setup. SQL Version 2014 AOAGs. I have a question about the M:\ holding 5 Filestream databases totaling 1.5TB. What will be the operational risks of running one ...
1
vote
1answer
55 views

WSFC Quorum query

I have an three node AlwaysOn AG setup, running on SQL Server 2012 SP3 in Windows Server 2012 R2. Node 1 and Node 2 are in the same physical location. Node 2 is the secondary replica. Third node acts ...
0
votes
0answers
18 views

SSISDB Catalog in sql server [duplicate]

I have SSIS feature installed but in what case I should configure SSISDB ? To my knowledge all sys.ssispackages resides in MSDB in SSIS. But my set up is new and it is AOAGs set up so just want to ...
2
votes
1answer
20 views

SQL Server AG in primary site with separate WSFC AG in secondary site

I would like some feedback from those experienced with SQL Server Availability Groups (AGs) in multiple sites. We have a scenario where there are five SQL Server 2012 Enterprise Edition servers in a ...
1
vote
1answer
39 views

Is it possible to have one server acting as secondary for two primaries on AG?

Can I have a server acting as secondary replica for two primary servers on an availability group? If possible, are there some concerns about performance in an async environment? Are listeners going ...
0
votes
1answer
49 views

Take full and differential backup on secondary replica - SQL Server 2014

I do have SQL Server 2014 high availability setup in Prod env. Server A – Primary, B-Secondary and C -DR. Server A to B are synchronous commit and automatic failover. Server A to C ...
1
vote
1answer
21 views

Physical Move of Secondary Replica to a new Location

We plan on moving a secondary replica of an SQL2014 AlwaysOn group to another physical location although it will have the same IP address after the move. The shutdown may be between 24 and 48 hours. ...
0
votes
0answers
43 views

Shrink Log file in an Always On Availability Group [duplicate]

My LDF file is too big (almost 500 GB) because we had some problems. I know that is not good to shrink files, but we need to do it this time. My database is using the FULL recovery model and is in ...
1
vote
1answer
94 views

Linked server to Availability Group Listener - is anyone successfully using one?

I edited the question hoping to check the basic stuff first. Does anyone have linked servers that successfully work with Availability Group listener? Have anyone heard of problems with linked servers?...
0
votes
2answers
50 views

Multiple SQL Server instance install question for AlwaysOn

I have a 2 node WSFC cluster with SQL Server 2014 installed on each for AlwaysOn. This is working fine. My question is can I install another instance of SQL Server 2014 on these nodes for another ...