March 23, 2015 at 3:42 am
[font="Tahoma"]Ok...so here is the requirement. I have a 2 node cluster with 2 standalone 2k14 instances having alwayson setup. As per client requirement we have created a client access point with a cname alias in dns to connect to secondary replica. Now, everytime whenerver the roles switch over one has to manually move this resource from the previous secondary node to the new secondary node. This is tedious, and should not be done manually either, so I am looking for a way to automate it so that as soon as the role switches over, the resource group after some time should also switch over to the current secondary.
I'm not sure how I can achieve this whether it's possible through tsql or we need to use powershell for the same. I'm not an expert in any of these, so would request the forum members to put some light on how this could be achieved, and if possible provide a script to do it. I appreciate all the help.
Env details
x\a (current primary)
y\2a (secondary)
client access point (resource group): aglreadtest
Let me know if any further info on this is reqd.
Regards,
Faisal[/font]
March 23, 2015 at 8:23 am
why don't you configure a listener for the availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2015 at 12:33 am
Thanks! Perry, we already have a listener for the availability group...this is a specific requirement from the client wherein they want a cname alias to be created so they can use that specific name to make a connection to the secondary always.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply