June 5, 2014 at 11:11 am
I will try to phrase this question as best I can. I need to set up replication to a SQL server database that is not in my current AlwaysOn Availability group. Currently in my AG I have only a primary and secondary server. I was trying to set up replication from my secondary server selecting all the tables from a database that is in one of my availability databases groups. My distributor is on another server however I am unable to set up the publication correctly on the secondary server. Is this because it is in a AG and this method is not possible? Or is there some other more logical approach I should take? Please advise.
June 5, 2014 at 12:51 pm
Have a look at this article:
http://msdn.microsoft.com/en-us/library/hh710046.aspx
Just remember, the distributor is going to be the weak link in all of this, as it can not be a member of an availability group.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply