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
32 views

Always on viability/configuration for very specific purpose

We need to know the risks/pitfalls of a particular AlwaysOn configuration. We want an AlwaysOn configuration with the following requirements(below). My question is: Is this a sound configuration or ...
0
votes
1answer
50 views

SQL Server AlwaysOn AG Synchronous

In a SQL Server AlwaysOn AG synchronous mode scenario, if the secondary node goes down, is the primary down as well (since it cannot write to and commit to the secondary)?
2
votes
1answer
109 views

High Availibility Solution to send data to multiple locations

I inherited a very interesting environment and I'm tasked with finding and implementing High Availability/Disaster Recovery solution as soon as possible. Simply speaking our environment looks like ...
2
votes
1answer
514 views

Availability Group database stuck in Not Synchronizing / Recovery Pending mode

While upgrading the storage in a SQL Server 2014 SP1 (12.0.4422.0) instance we ran in to an issue where two of the databases would not start on the secondary after restarting SQL Server. The server ...
3
votes
1answer
64 views

Traditional failover clustering vs. Availability Groups

I'm looking into Availability Groups to see if i can benefit from them, but I struggle to understand if I can or not. Today, we are running a traditional failover cluster with around 150 databases. ...
0
votes
1answer
39 views

Max redo speed on replica side in Availability Group

I heard about maximum 50 Mb/sec for receive and 50Mb/sec for redo. But really, I have only 20Mb/sec redo speed. This is speed from Perfmon, so I know about the following issue: AlwaysOn ...
2
votes
0answers
42 views

AlwaysOn Multi Subnet Configuration

Environment Two Nodes A & B A - Site/Subnet 1 B - Site/Subnet 2 File Share - at Site 3 We have an AG listener that has two IP addresses spanning the two subnets (1 up, the other down ...
3
votes
0answers
22 views

How to use a different vlan for mirroring in an availability group

I want to setup the following with SQL Server 2014 Enterprise and Windows Server 2012 R2. I have two nodes and a fileshare for witness. Both are virtual machines in the same vsphere cluster. To minize ...
0
votes
1answer
63 views

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

TL;DR: What possible solution(s) are there to practice AlwaysOn feature on SQL server 2014 installed on Windows 10 Home edition? I am learning Database Administration on my own and have installed ...
2
votes
1answer
95 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...
1
vote
1answer
58 views

Readable secondary

I set my readable secondary to read intent only and I ran my application without application intent = readonly and start a trace on the secondary node to make sure we are not reading from the ...
0
votes
0answers
77 views

Unable to create availability group

While trying to create an availability group, I am getting the below error. Can someone find the root cause of this? I even granted "create computer objects" permission, but it still did not work. ...
2
votes
1answer
38 views

SQL Always on Availability LSN Query

Please can somebody explain how the following works: Scenario: Two nodes in always on availability group configuration (all databases). If I have a backup job on node 1 to backup Full and Log ...
0
votes
0answers
126 views

AG Automatic Failover when SQL Server service shut down

I set up an availability group listener, and am able to failover manually without data loss. If I reboot the host OS, it fails over automatically. However, when I stop the SQL Service on the node ...
0
votes
0answers
76 views

Backup plan fails with error code 0x80004003

We have a maintenance plan that backups logs every 10 minutes at primary AlwaysOn group(don't sure that this is relevant info). Once in a while this plan's job fails with error: Code: 0xC0024104 ...
0
votes
0answers
13 views

Always On to separate Reads/Writes — safely doable with MSDTC cooked into app?

We are currently running SQL 2014 Enterprise Edition in AWS (EC2 instances, not RDS). We have a pressing need to separate out READS and WRITES, so that report queries don’t impact other processes. ...
3
votes
1answer
139 views

Multi Subnet Availability Group IP Requirement for Windows Failover Cluster

Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet? The instructions I am finding for a Failover Cluster Instance (FCI) in a ...
-1
votes
1answer
42 views

AlwaysOn Multi-Subnet Setup

Without using SAN-to-SAN replication, how does data synchronization occur across subnets in a multi-subnet AlwaysOn (AVG) configuration? I want to setup a separate VLAN (replica lan) to synchronize ...
1
vote
1answer
29 views

SQL Server AG - Is there any case for un-clustering prior to certain operations?

I have a software company asking me to remove a database from a synchronous availability group prior to them running their upgrade scripts. They are convinced that this will increase the execution ...
3
votes
1answer
101 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
2answers
99 views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...
1
vote
0answers
45 views

SQL Server 2012 AG replication issues

We just went away from SQL Serer clusters in SQL Server 2008 to SQL Server 2012 with AG – have five servers with replicas in a secondary datacenter and syncing over a dedicated eline/LAN layer 2 ...
3
votes
2answers
338 views

What to do when your AlwaysOn cluster loses quorum?

I was reviewing our company DR procedures and when I looked online for solutions to an AlwaysOn Cluster losing quorum, to compare to. I was three pages into google results before finding the first SE ...
3
votes
2answers
67 views

How is an AAG listener implemented? Where does it run?

I'm fairly new to SQL Server but generally well versed in RDBMS and network topics. I'm trying to wrap my head around AlwaysOn Availability Groups. I've read a handful of articles on MSDN and Googled ...
1
vote
0answers
53 views

Collecting DB Used Space (MB) from SCOM on an Always-On DB

My client has asked for database sizing for capacity planning. I am trying to use System Center Operations Manager (SCOM), however when I get to the Always-On Cluster, it doesn't seem to display the ...
5
votes
1answer
2k views

SQL Server AlwaysOn database stuck in Not Synchronizing / In Recovery mode after upgrading. Error: Cannot open database '…' version 782

While testing an upgrade from SQL Server 2014 SP1 (12.0.4422.0) to SQL Server 2016 CTP 3.2 (13.0.900.73) I was following the recommended update process and ran into an issue where the database would ...
1
vote
1answer
87 views

Shrink Transaction Log While Using AlwaysOn Availability Group 2014

I'm running a SQL Server 2014 Availability Group with a single secondary in asynchronous mode. My logs in all the Availability Group databases keep growing and the built-in shrink tool only takes ...
3
votes
2answers
362 views

Availability Group Listener

I'm looking at AlwaysOn availability groups. The more I look at it the more it appears that the availability listener group is a single point of failure. Where exactly does the listener actually run? ...
1
vote
0answers
36 views

Trans Replication and Always On Listener Group Name

We have currently (SQL Server 2012 STD) which is continuously replicating from 8 different database server for reporting purpose to server which is on SQL 2008R2. We would like to create an Always On ...
5
votes
1answer
52 views

Checking SQL AlwaysOn backup target with fn_hadr_backup_is_preferred_replica, different answers with different permissions

I've implemented AlwaysON backup with Ola's script, those are running fine on designated server configured for backup. I would like to automatically check backups using sql-scripts fired from a ...
3
votes
1answer
99 views

SQL Server 2014 Always On .. can i have replication without a listener

I am still a novice with SQL Server Always On, having recently converted from a standalone server to an always on configuration. I currently have 2 nodes in the same subnet configured in my ...
3
votes
0answers
33 views

Incremental statistics with failover

We have two AlwaysOn availability replicas - secondary readable. We do have an incremental statistics on a large table. When a failover happens, SQL Server tries to update statistics on that table ...
0
votes
2answers
75 views

Avoid user login Directly to AlwaysOn High Availability Primary

I have setup an AlwaysOn High Availability in Sql Server 2014. my IP addresses are according to this : 192.168.1.189 -- Listener 192.168.1.180 -- Replica 192.168.1.181 -- Primary Right now users ...
6
votes
0answers
257 views

Why does resource in AlwaysOn fail?

I have two SQL Servers (12.0.4100.1) and Availability Group (AG) configured on them. Sometimes some server hangs. It responds on ping, but RDP connection are not available, SQL Server doesn't respond ...
0
votes
1answer
59 views

Availability Group failover stuck in Resolving State

I am setting up a lab for testing automatic failover for SQL Server I have a 2 node WSFC (SQL-CLUSTER-TEST-01) with the nodes SQL-TEST-01 SQL-TEST-02 A listener SQL-HA-GRP-01 My initial testing ...
1
vote
0answers
23 views

Database Consolidation / AlwaysOn Availability Groups

How can I calculate the potential savings in RAM, Storage and CPU by consolidating a certain number of servers into single server? How can I go about consolidating the BI servers' and the OLTP ...
2
votes
0answers
67 views

How to avoid Network issues for SQL Server 2012 AlwaysOn

I have SQL Server 2012 and have setup AlwaysOn for High Availability. The infrastructure is on Azure VM's. After moving to this setup, we are frequently observing Network issues which either causes ...
3
votes
1answer
248 views

Misaligned Log IO Issues and Unmatched LUN sector sizes in AlwaysOn

I'm running into a little bit of a snag on a high log send queue in a 2014 SP1 Asynchronous Mode AlwaysOn Environment with a secondary replica in Azure. For one of our higher transaction volume DB, ...
0
votes
0answers
137 views

AlwaysOn ReadOnly Routing

I am having some trouble setting up the AlwaysOn readonly routing. I'd appreciate if someone can help me solve this issue. Setup: 3 Nodes in Primary Datacenter (NODE1, NODE2, NODE3) 1 Node in DR ...
1
vote
2answers
85 views

SQL Server AlwaysOn from multiple origins to a single secondary replica server

I started working in a small company which have three separate databases, for three different systems. They are SQL Server 2008, 2012 and 2014, installed in different servers. We'd like to set up an ...
0
votes
1answer
54 views

SQL Server - How does Always On in a shared nothing config maintain transaction durability during a failover?

I've been reading up on Always On, and I was wondering how transactional durability is maintained during a failover when using a shared nothing configuration. The only things I can find on google ...
0
votes
0answers
25 views

SQL alwayon azure VM

Please help me I have to finish the task tomorrow morning The Scenarios as below : ALL VMS in AZure SQLSRV1(192.168.1.X) SQLSRV2(192.168.1.X) both in the same cloude service with ip 104.40.151....
0
votes
1answer
61 views

BACKUP Detected Corruption in the database log

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...
1
vote
0answers
65 views

AlwaysOn Primary Showing as Question Mark

If I look in the dashboard for my AlwaysOn implementation I can see my groups are synchronised and no data loss. They also failover successfully but when looking in the Group folder list under ...
0
votes
1answer
29 views

SQL server 2012 Enterprise [duplicate]

Will CDC work with SQL Server Always on Availability groups? Do you need to set up CDC on both/multiples nodes if using Availability Clusters?
0
votes
0answers
56 views

How do I alter containment to none for partially contained db with default language?

Experimented with Contained DBs in an Always-On Availability Group and decided against them. I want to UN-contain the databases now but when I run: alter database <myDB> set containment = NONE ...
0
votes
1answer
112 views

SQL Server 2012 AlwaysOn performance best practice

Is it best practice to have 2 Primary then 1 Secondary for SQL Server AlwaysOn Availability Groups? My purpose for having 2 Primary instances is to balance the database load. (e.g. my db1 and db2 is ...
2
votes
1answer
107 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
1answer
86 views

Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?

I am using sys.fn_hadr_backup_is_preferred_replica to query the databases on each of my Availability Group replicas to figure out if the database should be backed up on that replica - then, if the ...
2
votes
1answer
102 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 ...