Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [alwayson]

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.

33 questions
3
votes
0 answers

Windows Server Failover Clustering - cannot choose desired subnet when creating

I'm setting up a new WSFC cluster, intended for SQL HA, but that's not actually important as yet. Node A has: An IP in Subnet 1: this is where the machine's "primary" IP is, set by the hoster. An IP in Subnet 2: this is subnet intended for…
Nik
  • 228
  • 3
  • 14
3
votes
2 answers

Error configuring File Share Witness in a Windows 2012R2 Cluster

I'm learning how to configure a simple W2012R2 Cluster for a AlwaysOn Basic Availability Group. I have this VM scenario: - 1 DC (outside the cluster) - 2 SQL Server Standard 2016 (in a Cluster) I've created a File Share in the DC to set it as File…
Farlop
  • 193
  • 1
  • 7
3
votes
2 answers

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

I am looking at HA options for SQL 2012 Standard. I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot have an alternative DB configured, only a single…
mwiggs
  • 33
  • 4
3
votes
2 answers

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 data center and has no votes (node weight of…
Steven Murawski
  • 1,570
  • 3
  • 14
  • 25
3
votes
1 answer

SQL Server Always On Availability Group Zero Downtime Update Procedure

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary. The question is - what is the optimal way to install Microsoft Updates on the servers in the cluster? I have struggled to find good, clear…
A X
  • 382
  • 2
  • 8
  • 23
2
votes
1 answer

AlwaysOn SQL VNet Migration from Azure V1 (ASM) to V2 (ARM)

Hoping someone can help! Currently in the middle of planning a migration from Azure Service Manager to Azure Resource Manager. Not able to find any documentation and thought I would reach out. When using the method of Move-AzureVirtualNetwork to…
Lachie White
  • 155
  • 8
2
votes
0 answers

Windows Failover Clustering Wont Release IP Address

I have setup a windows failover cluster on two servers on Windows 2012R2 with a file share for quorum. On top of this I have deployed SQL Server 2016 Always On Configuration and if I manually fail over between the two servers everything works…
ollie
  • 121
  • 3
1
vote
0 answers

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the AlwaysOn Failover Cluster instance to achieve…
MidTierDeveloper
  • 49
  • 1
  • 5
1
vote
1 answer

MS SQL 2016 AlwaysOn cluster on Win2012R2 - AGs failover if File Share Witness is down

Our current setup includes: eight (8) Windows 2012 R2 nodes in single Failover Cluster, no shared storage, File Share Witness (on DC) MS SQL 2016 AlwaysOn with a few AG groups default 'If resource fails' policies Cluster Validation Report shows a…
Arseny V.
  • 85
  • 2
  • 10
1
vote
0 answers

Windows Failover Cluster node in Azure - Assigning a cluster IP address

I've built a 2-node Windows Server 2012 R2 failover cluster, one node being in my on-premises network and one being an Azure (Resource Manager deployment model), in part following this MS article In step 7 of the section Create the WSFC Cluster, the…
newguise
  • 66
  • 2
1
vote
0 answers

SQL Server 2016 Always Encrypted and AlwaysOn readable secondary connection error

I've used Always Encrypted in SQL 2016 to encrypt the data in a few columns of a table in my application. Always encrypted appears to be set up correctly, because I can see the encrypted data in SSMS and the decrypted data in my application. My…
NorthFork
  • 151
  • 6
1
vote
0 answers

Unable to create cluster in Windows Server 2012 R2

I am trying to create a cluster in between two networks/gateway and validation is perfectly passing and after that i am getting error as An error occurred while creating the cluster and the nodes will be cleaned up. Please wait... where as i see in…
mohammed
  • 11
  • 2
1
vote
1 answer

How to setup user accounts on a secondary server in High Availability?

Working with two Microsoft SQL 2012 servers in Always On High Availability configuration running on Windows Server 2012 R2. Setup works well and failover is almost flawless. However, the software that connects to database (or high availability…
jM2.me
  • 301
  • 2
  • 6
  • 15
1
vote
0 answers

Run generic Windows Service with affinity for the Primary Replica of an SQL Server AlwaysOn Availability Group

Is it possible to configure a generic Windows service in a Windows Server Failover Cluster such that the service always runs on the same machine as the Primary Replica (read/write) of an SQL Server AlwaysOn Availability Group? How would this be…
Hydrargyrum
  • 111
  • 4
1
vote
0 answers

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 single DB. Recently we have SQL Always On. After…
zakirjt
  • 11
  • 2
1
2 3