High Availability/Disaster Recovery (HADR) feature in Microsoft SQL Server 2012 and above.

learn more… | top users | synonyms

0
votes
2answers
36 views

Windows Server Failover Clustering with two servers

I was going to create a Windows Server Failover Cluster, in order to set up MS SQL Server AlwaysOn Availability Groups. As a prerequisite of failover clustering, I've created and configured an ...
0
votes
0answers
9 views

No messages received on Queue after Failover in SQL Always On

We have an Application, which uses Service Broker to receive notifications from the SQL Server. The application works fine when we don’t have SQL Always On enabled, and when we are interacting with a ...
0
votes
1answer
121 views

Automatic failover in SQL server alwayson availability group

I have 2 nodes in my SQL server fail over cluster. I use SQL server 2012 always on feature for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
1
vote
1answer
199 views

SQL AlwaysOn auto fail over due to disk

All, I'm in the process of evaluating SQL AlwaysOn, and everything is failing over as expected, except in one circumstance, when the disk goes belly up. In this case, SQL does nothing, other than ...
0
votes
1answer
165 views

AlwaysOn Automatic Failover Using Two Nodes with SQL Standalone Instances

We are building a new SQL 2012 cluster for our web environment. We decided to use two nodes and utilize AlwaysOn Availability Groups for High Availability. Server01 and Server02 have had a Standalone ...
3
votes
2answers
568 views

Dealing with Stretch (Geo) Cluster Node Failures

Scenario: Three node (shared nothing) cluster on Windows Server 2012. Two nodes in the primary data center, both with votes (node weight = 1), and a file share witness. The third node is in a remote ...