glugingboulder (3/17/2014)
Thanks for reply, i understand that part, but what if you have this example.10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.
Essentially you have a massive windows cluster with pockets of availability groups defined throughout.
I didn't test it but I think that should be fine. The actual requirement is the availability replica should be part of the instances on the nodes of same WSFC.
AG1 and AG2 should have different set of databases.
--
SQLBuddy