AlwaysOn config?

Question

AlwaysOn config?

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

david.alcock SSCertifiable Points: 6021 More actions · Answer 1

May I ask another question Perry. With regards to AlwaysOn, is it possible to have a 2 node cluster, availability group configured accordingly and then add a secondary replica from another instance of SQL that is not in the cluster?

Many thanks

D

'Only he who wanders finds new paths'

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

david.alcock (1/22/2014)
May I ask another question Perry. With regards to AlwaysOn, is it possible to have a 2 node cluster, availability group configured accordingly and then add a secondary replica from another instance of SQL that is not in the cluster?
Many thanks
D

All nodes containing AO group replicas must be part of the same cluster, this is so that the listener clustered resource can be failed to a node with a secondary instance taking over as a primary.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

david.alcock SSCertifiable Points: 6021 More actions · Answer 3

So, and apologies for my many, many question, the likes of this article here

http://technet.microsoft.com/en-us/library/ff878473.aspx

the secondary replica would have to be on the same cluster?

Thanks

D

'Only he who wanders finds new paths'

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

You can have an AO group span different clusters but its only supported for migration purposes.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

david.alcock SSCertifiable Points: 6021 More actions · Answer 5

But if it was non cluster, just stand alone?

Please, tell me to bu@@ar off if you grow tired of my questions!!!!

David

'Only he who wanders finds new paths'

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

All nodes must be part of the same cluster.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉