September 15, 2015 at 10:27 am
I am planning to have AlwaysON Availability Groups 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 4 as Subscriber
Server X as Remote Distributor ..
If i create Publications on Server1 (primary replica) to subscriber 4 servcer, will the publication be created automatically in Secondary Replica Server2 ?
or do i have to create manullay using GUI/T Sql on Both Servers?
I read below but could get my answer
https://msdn.microsoft.com/en-us/library/hh710046(v=sql.120).aspx
September 16, 2015 at 5:21 am
nari.koud (9/15/2015)
I am planning to have AlwaysON Availability Groups setup between Server 1 and Server 2Server 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 4 as Subscriber
Server X as Remote Distributor ..
If i create Publications on Server1 (primary replica) to subscriber 4 servcer, will the publication be created automatically in Secondary Replica Server2 ?
or do i have to create manullay using GUI/T Sql on Both Servers?
I read below but could get my answer
https://msdn.microsoft.com/en-us/library/hh710046(v=sql.120).aspx
Do you have replication configured already?
You're asking a lot of questions around HA and AlwaysOn, please read through my stairway to HA starting at this link[/url] for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply