September 18, 2014 at 7:22 am
Hello:
I know now that AlwaysOn feature HAS to be installed/configured on a Windows Clustering environment, BUT the secondary replicas, like the Disaster recovery replica residing in a different Data Center HAS to be also in a Windows Clustering environment or can it reside on a SINGLE SQL Server INSTANCE?.
Appreciate your help.
Thanks
September 18, 2014 at 7:31 am
All of the nodes involved in the AlwaysOn group must be part of the same windows cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 7:33 am
Pablo Campanini-336244 (9/18/2014)
Hello:I know now that AlwaysOn feature HAS to be installed/configured on a Windows Clustering environment, BUT the secondary replicas, like the Disaster recovery replica residing in a different Data Center HAS to be also in a Windows Clustering environment or can it reside on a SINGLE SQL Server INSTANCE?.
Appreciate your help.
Thanks
Standalone SQL Instance works for secondary replica.
I have implemented for DR setup.
September 18, 2014 at 9:08 am
Why would you want to put your replica on a stand alone for DR? The AlwaysOn option was built for DR auto failover...hence the name High Availability. I wouldn't recommend using AlwaysOn for with a stand alone instance for a DR site. Nope.
MCSE SQL Server 2012\2014\2016
September 18, 2014 at 10:10 am
In a standard always on config all replicas are stand alone instances. However, the nodes must all be members of the same windows cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 10:26 am
Perry Whittle (9/18/2014)
In a standard always on config all replicas are stand alone instances. However, the nodes must all be members of the same windows cluster
Yes Perry I know, I have stood up several AlwaysOn cluster...Thank you though.
MCSE SQL Server 2012\2014\2016
September 18, 2014 at 10:51 am
It wasnt for your benefit, as an MCSA i would hope you do know 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply