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
1answer
22 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 ...
0
votes
0answers
22 views

Replication Subscribers and AlwaysOn Availability Groups (SQL Server)

AlwaysOn Availability Groups with Replication Subscribers is running successfully with one publisher using below command.. -- commands to execute at the publisher, in the publisher database: EXEC ...
0
votes
0answers
10 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
3answers
272 views

Availability Group how to determine last Failover time

I'd just like to know if there is any way to query when the AG group failed over. eg - this is the Primary Replica now, but I'm pretty sure it was the secondary yesterday? How can i find when the ...
7
votes
2answers
4k views

AlwaysOn Availability Group Automatic Failover does not work

Playing with AG setup I have the WSFC up and configured with two nodes in one availability group called DevClusterOnline. Both nodes (DEV-AWEB5 primary, DEV-AWEB6 secondary) are running Windows Server ...
0
votes
1answer
16 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
1answer
320 views

delete WSFC 2012 cluster role/group fails

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ---...
0
votes
0answers
10 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 ...
5
votes
1answer
5k views

AlwaysOn Availability Groups go to Resolving status

We have a two-node cluster set up running SQL Server 2012 on Windows Server 2012 R2. The base cluster consists of only those two nodes. The quorum is set up as node + disk majority, with a shared ...
3
votes
2answers
2k views

Removing secondary replica from SQL Availability Group causes large log file

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...
0
votes
1answer
26 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
42 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....
3
votes
1answer
41 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
22 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
21 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 ...
0
votes
1answer
50 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
2answers
29 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 ...
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 ...
3
votes
1answer
142 views

Mixed editions in Availability Group?

Looking to consolidate several different older SQL serves into one AG with an ent lic when Sql Server 2016 is released. Plan is to have a primary, a sync passive secondary, and an async third instance ...
1
vote
0answers
39 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 ...
1
vote
1answer
46 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 [...
2
votes
1answer
122 views

Availability Groups - Can async replica delay failover of sync replica?

Availability Groups SQL Server 2012. Node 1 and Node 2 in primary data centre - sync mode for HA Node 3 in dr data centre - async mode for DR If a manual failover is performed between node 1 and ...
0
votes
0answers
20 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)...
0
votes
1answer
41 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 ...
9
votes
4answers
979 views

SSMS Registered Servers with ReadOnly Application Intent

We are working on SQL Server 2014 POC testing with AlwaysOn and one of the user asked about saving the configuration of SSMS with ReadOnly Intent using the registered servers in Local server group. ...
1
vote
1answer
37 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 ...
1
vote
1answer
2k views

RegisterAllProvidersIP 1 or 0 For The Cluster Resource

I have set up clustering across two sites, at each site there is a single instance of SQL 2014 enterprise and I am using Availability Groups. I know I need to set RegisterAllProvidersIP for the AG ...
3
votes
1answer
47 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 ...
3
votes
0answers
46 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 ...
0
votes
1answer
54 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
34 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, ...
2
votes
1answer
1k views

Fastest way to migrate database to AlwaysOn cluster

I want to make the fastest migration plan to move a SQL Server database in simple recovery from a standalone server (SQL 2005) to a two node AlwaysOn cluster in full recovery. Some databases are ...
1
vote
1answer
36 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
1answer
659 views

“Skipping the default startup of database” SQL notification for AlwaysOn Cluster

So I set up our SQL servers to notify us of alerts at severity 17 or higher (as advised by various SQL Server articles). I've done this to each node of a SQL Server Always On Availability Cluster, ...
16
votes
5answers
440 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 ...
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 ...
0
votes
0answers
22 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
32 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? ...
2
votes
1answer
176 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 ...
0
votes
1answer
36 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 ...
1
vote
1answer
114 views

Shared network location in Availability Groups configuration

I am configuring Availability Groups feature in azure virtual machines nodes. In the below screen wizard, it's asking me for shared location. where and how I need to create this shared location? Do ...
11
votes
1answer
164 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 ...
-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 ...
2
votes
1answer
103 views

Why take full backups when you can do COPY_ONLY?

With a SQL Server 2012 availability group, you can only take COPY_ONLY full backups on replica. You can make regular BACKUP LOG. As it's possible to restore logs backups after a database restoration ...
2
votes
1answer
77 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 ...
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? ...
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
92 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?...
17
votes
5answers
11k views

SQL Server Agent Jobs and Availability Groups

I'm looking for best practice in dealing with scheduled SQL Server Agent jobs in SQL Server 2012 availability groups. Maybe I missed something, however at the current state I feel that SQL Server ...