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)

5
votes
0answers
79 views

Always On Availability Group, Always redirect user to read only instance

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...
4
votes
0answers
95 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 ...
4
votes
0answers
113 views

Migrating VLDB to AlwaysON AG

I have been using AlwaysON AG for a long time now and currently have about 10TB of data across 120 databases and 3 AG groups for any application that is on SQL 2012 with great success. Each AG group ...
3
votes
0answers
28 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 ...
2
votes
0answers
34 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 ...
2
votes
0answers
404 views

SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy

I have an environment with 2 Windows Server 2012 R2 servers, both with SQL Server 2014 Expensive edition. Whenever a change happens in the AGs (such as: AlwaysOn Availability Groups connection with ...
2
votes
0answers
98 views

SQL Server Always On Failover Cluster Design

I have two databases. One I'd like to set up in an availability group between two servers (two instances, one on each server). The database is not huge and I'm not expecting it to grow ...
2
votes
0answers
51 views

Replacing Database in High Availability Group Enviroment

Looking for some advice regarding replacing a database within a SQL 2012 High Availability Group environment setup as synchronous with auto failover. A little bit of background on the reason for this. ...
2
votes
0answers
63 views

Alwayson Database Recovery Failure during TDE encryption

Last week I enabled TDE encryption on my AlwaysOn Availability Group databases of SQL Server 2012. During the encryption of one of the larger databases, bigDB (~200gb) a failover event occurred. Of ...
2
votes
0answers
210 views

AlwaysOn FCI + HA Setup Question

I am planning to create FCI + HA solution in the same datacenter, but running into some problems. I'd really appreciate if someone can provide some guidance. Here is the current configuration (All ...
2
votes
0answers
259 views

always on availability group with different speed disks

I'm looking to set up SQL Server 2012 installation with an Always On Availability Group, where the 'passive' replica will be hosted at another site on the WAN and using synchronous data commit - the ...
2
votes
0answers
66 views

What is correct process to physically move an availability replica to another location

Current situation is we have 3 SQL Servers with one availablity group and we plan on moving one of the secondary replicas out of HQ to another location. There will be the span of a few hours between ...
2
votes
0answers
2k views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
1
vote
0answers
20 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
0answers
30 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 ...
1
vote
0answers
37 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 ...
1
vote
0answers
37 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 ...
1
vote
0answers
29 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 ...
1
vote
0answers
16 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 ...
1
vote
0answers
37 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 ...
1
vote
0answers
70 views

Securing High-Availability on Partitioned Database

I have a 90GB SQL 2012 database I am sharding over 3 database and I plan on growing as more clients are coming. A new customer came to us with a demand to know on we secure high-availability in our ...
1
vote
0answers
45 views

IP from a different subnet is registered even after node and resource were removed

We run two SQL server at primary site in AlwaysOn High Availability Group on subnet 10.10.0.0/24 A third SQL server is running on secondary site in a different subnet 10.10.1.0/24 We have had third ...
1
vote
0answers
32 views

SQL AlwaysOn Availability Groups network performance

Our customers are asking to implement our products while configuring AlwaysOn Availability Groups ( between two FCI with Asynchronic commit ). The DR server is geographically far from the Production ...
1
vote
0answers
33 views

SQL 2014 Availability Group Cluster or Listener

We recently deployed a setup of SQL 2014 availability groups and we are having some difficulty with the failover. Setup: Two windows server 2012R2 VMs in a windows cluster with a CNAME pointed at ...
1
vote
0answers
50 views

AlwaysOn Availability Groups

We are looking at setting up SQL AlwaysOn availability groups in the following environment: we have two SQL 2014 Enterprise Servers on two different host Hyper-V 2012 servers. They each have ...
1
vote
0answers
25 views

AlwaysOn AG Live Migration

A couple of thoughts on AlwaysOn AG migrations: Is there a reason why Microsoft didn't implement similar technology to Hyper-V Live Migration to AlwaysOn AGs so that the buffer pool and cache are ...
1
vote
0answers
920 views

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval

I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...
1
vote
0answers
237 views

SQL Server Management Studio with Multi subnet HADR cluster

We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works. However, SSMS connections require manual ...
1
vote
0answers
110 views

Change Data Capture for Asynchronous Secondary Replica

MSDN states the following in Active Secondaries: Readable Secondary Replicas (AlwaysOn Availability Groups) for SQL Server 2014: Limitations and Restrictions: Change tracking and change data ...
1
vote
0answers
126 views

How to modify an existing AlwaysOn Availability Group IP

I have an unusual question regarding AlwaysOn Availability Group configuration. I have built out an AOAG cluster on a VM. The build out did not use a Heartbeat network as I had originally requested ...
1
vote
0answers
429 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, ...
1
vote
0answers
197 views

Adding a distributor for availability groups

According to this MSDN article, I need to add a distributor. http://msdn.microsoft.com/en-us/library/hh710046(v=sql.110).aspx I'm confused by this particular statement: The distributor should not be ...
1
vote
0answers
644 views

AlwaysOn Availability Group: Users on Secondary Server

We have an AlwaysOn Availability Group setup (DB1+DB2) and also a web server (Web1) outside of the domain that we need to connect to the AG using Windows Authentication. The following Windows ...
1
vote
0answers
543 views

Can not ping Always On listener from outside primary node

I just setup SQL Server 2012 (on Windows Server 2012) Always On feature and have a problem with connecting to SQL Server Listener from non-primary node (it works from primary node though). Here is ...
0
votes
0answers
27 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. ...
0
votes
0answers
35 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
20 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
8 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. ...
0
votes
0answers
18 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 ...
0
votes
0answers
64 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 ...
0
votes
0answers
18 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 ...
0
votes
0answers
28 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
0answers
29 views

Is there a way to set up DNS to point to Always-On Read-Only node w/out ApplicationIntent?

I know that we can use ApplicationIntent=ReadOnly to connect to the secondary read-only nodes in an AG setup. Is it possible in some way to tell the DNS server which node is which on failover so we ...
0
votes
0answers
35 views

SQL Server 2012 , TDE key rotation for a database in Availabilty groups

I need to do TDE Key Rotation for a database in availability groups in SQL Server 2012 for PCI Compliance. Need help please on procedure to follow .
0
votes
0answers
146 views

Cluster Failure

Earlier this evening we received notice of failures in regard to the availability groups. Our plan is to fail it back over tonight, but we'd like to know the possible root cause of the initial ...
0
votes
0answers
30 views

2012 Always on (AG only) Where should the Windows Cluster SIT?

2012 Always On and the Windows Cluster, shouldn't the Windows Cluster be on a separate server like the Domain controller/BackupDomainController? With Windows clustering Services on each node ...
0
votes
0answers
19 views

Login synchronization in 2012 AlwaysOn

I have a rather unique situation (or so it seems since there isn't anything I've found on the web about this). I have an AlwaysOn Availability Group configured without HA Failover, to an asynchronous ...
0
votes
0answers
62 views

Do I need a separate server for Quorum?

We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: 1 Primary Replica and another is Secondary Replica. The question is, do we need a separate server ...
0
votes
0answers
92 views

Sleeping queries blocking rebuild index and update statistics job in Always on

At one of your client sides we have configured Always on with synchronous mode.Also we have schedule rebuild index and update statistics job which runs in night every alternate day. the issue is ...
0
votes
0answers
716 views

SQL AlwaysOn Failover Due to Missed Heartbeats

I have setup SQL AlwaysOn between primary and DR data centers. Here is the setup: Primary data center: Server1 (Primary), Server2 (Sync Commit Secondary), Server3 (ASync Commit Secondary) DR data ...