always on

  • 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??

  • 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" 😉

  • 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.

  • 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" 😉

  • 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...

  • 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

  • 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