AOAGs Join Only Option

  • Super Cat

    SSCertifiable

    Points: 7316

    Quick one.

    When using the join only option whilst adding a Db to an AOAG. Is the db restored and left in WITH NORECOVERY when applying the last .trn file.
    Or do you recover the db first?

  • Super Cat

    SSCertifiable

    Points: 7316

    Sorted. It's left in recovery mode as I thought.

  • Alexander Zhang

    Default port

    Points: 1437

    Before using the join only option, I think you need to restore from DB and log backup, and keep it with NORECOVERY. After that, DB will be in Synchronized/Synchronizing status.

    GASQL.com - Focus on Database and Cloud

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

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