Remote Distributor in Always Availability Groups

I am planning to have AlwaysON Availability Group setup between Server 1 and Server 2

Server 1 -->Publisher-->2014 SQL Enterprise edition-->Windows Std 2012 --> Always on Primary Replica

Server 2 -->Publisher(when DR happens)-->2014 SQL Enterprise edition-->Windows Std 2012 --> Secondary  Primary

Server 3 -->Subscriber-->2012 SQL Enterprise edition-->Windows Std 2012 --> NOT involved in Always ON 

Server 4 -->Subscriber-->2012 SQL Standard edition-->Windows Std 2012 --> NOT involved in Always ON 

Server 5(VM)-->Distributor-->2012 Standard edition-->Windows Std 2012-->not involved in Always ON


i know Publisher and subscribers can be mix match of 2014 and 2012

From the above scenarios can i use (VM)SQL2012 std. as Distributor ? while publisher is being SQL 2014 ent.?

please let me know 

September 11th, 2015 4:37pm

Hi, it doesn't appear to be supported

https://msdn.microsoft.com/en-us/library/ee240655(v=sql.120).aspx

'For all types of replication, the Distributor version must be no earlier than the Publisher version.'

Free Windows Admin Tool Kit Click here and download it now
September 12th, 2015 11:16pm

Publisher and distributor should be always should be on same  versions.
September 13th, 2015 12:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics