AG Question

  • is it possible to make secondary database to read/write in secondary replica in always on .

  • No, it can be set to read only.  There are no other options.

    If you need to have two separate databases that need to be in sync and allow read/writes, you will need to implement merge replication, bi-directional transactional replication, or peer to peer replication.

    Depending upon what your needs may be would determine the proper approach.

    What problem are you attempting to solve?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

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

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