Post reply

Can an availability group secondary db be a replication publisher

  • February 27, 2018 at 8:59 am

    #403143

    Hi All,
    I have a 3 node AOAG setup:
    Primary Site: Node1 and Node2
    DR Site: Node3

    I want to be able to present a transactional database via replication as we have some major querying to do.
    I cannot touch the Node1 or Node2 for the job only DR. So My question is can I setup the DR (Node3, ReadOnly) as a publisher to a subscriber on another box?
    Any suggestions or is this a straight NO?
    thanks

  • February 28, 2018 at 10:22 am

    #1981501

    Radders - Tuesday, February 27, 2018 8:59 AM

    Hi All,
    I have a 3 node AOAG setup:
    Primary Site: Node1 and Node2
    DR Site: Node3

    I want to be able to present a transactional database via replication as we have some major querying to do.
    I cannot touch the Node1 or Node2 for the job only DR. So My question is can I setup the DR (Node3, ReadOnly) as a publisher to a subscriber on another box?
    Any suggestions or is this a straight NO?
    thanks

    Sorry, if the DB is in AG, I don't think you can do it since DR is NOT writable. You probably need other solutions, such as SSIS package, etc.

    GASQL.com - Focus on Database and Cloud

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply