High Availability/Disaster Recovery (HADR) feature in Microsoft SQL Server 2012 and above.
High Availability/Disaster Recovery (HADR) feature in Microsoft SQL Server 2012 and above.
Questions tagged [alwayson]
34 questions
0
votes
2 answers
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 Active Directory using two servers. One server is…
Jack
- 113
- 1
- 2
0
votes
1 answer
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!
How can I enable automatic fail over?
Pooya Yazdani
- 277
- 5
- 12
0
votes
1 answer
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 Instance of SQL installed and both have been…
Dion Pezzimenti
- 177
- 1
- 1
- 10
0
votes
0 answers
SQL Server 2012 AAG not failing over in case of SQL Server crash/stop
I have created the following structure:
Two hardware servers with Windows Server 2012R2 installed, SQL Server 2012R2 installed. Then Windows went fully updated and SQL Server was patched to SP4, current version is reported as 11.0.7493.
WSFC formed…
Vesper
- 794
- 1
- 9
- 32