May 18, 2015 at 12:50 am
I have a Database A on one instance, and database B on the same instance.
A is publisher and B is subscriber in transactional replication.
can i setup Availablility group and keep both the DBs in the same group ?? and after failover my replication between A to B will be continue??
May 18, 2015 at 3:34 am
Please read my stairway to alwayson starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 3:55 am
its a nice article but still not answering my query, whether replication will continue after failover or if on the same instnace publisher , distributor and subscriber will be kept.
May 18, 2015 at 4:48 am
forget the replication for now, you need to understand how alwayson availability groups work and what the pre reqs are for them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 6:09 am
but in my production environment i have 4 DBs ... in which 3 DBs are publisher and one is subscriber.. all 3 DBs are replicating some of their objects in subscriber DB. all are avaialable in same instance.. if i forget about the replication, how would i achieve this using availability groups if i keep them all in on AG...
May 18, 2015 at 8:37 am
Zeal-DBA (5/18/2015)
but in my production environment i have 4 DBs ... in which 3 DBs are publisher and one is subscriber.. all 3 DBs are replicating some of their objects in subscriber DB. all are avaialable in same instance.. if i forget about the replication, how would i achieve this using availability groups if i keep them all in on AG...
You would be mixing 2 VERY complex subsystems, each with LOTS of provisos, limitations, gotchas, caveats, bugs, etc. I would NEVER EVER recommend a client attempt to establish such a configuration as you are considering.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 18, 2015 at 9:59 am
Zeal-DBA (5/18/2015)
but in my production environment i have 4 DBs ... in which 3 DBs are publisher and one is subscriber.. all 3 DBs are replicating some of their objects in subscriber DB. all are avaialable in same instance.. if i forget about the replication, how would i achieve this using availability groups if i keep them all in on AG...
In the setup you describe above you cannot use AlwaysOn availability groups.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply