Post reply

Can a database be removed from single AG replica without affecting other replicas

  • December 15, 2016 at 10:17 pm

    #332823

    Hi,

    In case of multiple AG secondary replicas, can a database be safely removed from only one of the secondary replica without any impact on other replicas?

    I don't want to completely remove the database from AG because adding it back to AG later will require restoring the database on to multiple secondaries.

    Thanks.

  • December 16, 2016 at 9:43 am

    #1918444

    praveen_vejandla (12/15/2016)

    Hi,

    In case of multiple AG secondary replicas, can a database be safely removed from only one of the secondary replica without any impact on other replicas?

    I don't want to completely remove the database from AG because adding it back to AG later will require restoring the database on to multiple secondaries.

    Thanks.

    either you're removing it from the group or you're not

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 16, 2016 at 4:34 pm

    #1918517

    Thanks for the reply.

    How can we perform maintenance like relocation of data files for a database on one of the secondaries without breaking AG and without impacting any other secondary replicas.

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

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