locked
Secondary Replica Shutdown RRS feed

  • Question

  • I have an AlwaysOn availability group with two secondaries.

    I need to move one of the secondary to another physical location.

    It will require one of the secondaries to be down 2-3 days.

    What steps needs to be down prior to shutting down the secondary replica.

    Thank you.

    Wednesday, February 3, 2016 2:07 PM

Answers

  • Hi miguelh,

    You don't have to shut down the secondary replica before move it.

    As mentioned in your another thread, you will move one of two secondary replicas of an AlwaysOn group to another physical location and the server will have a different subnet.

    And I have suggested you firstly remove the secondary replica from your AlwaysOn availability group following the instructions in this  article. Besides, take backup of all the databases on your secondary replica in advance and make sure that no applications connect to the secondary replica if you persist to shut down it.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support



    Thursday, February 4, 2016 8:20 AM

All replies

  • Hi miguelh,

    Its very large step to move the database configured in always on so please find the article below.

    Moving database in AlwaysOn

    Please Mark me as answer if above link helps you .

    Regards

    ChetanV.

    Wednesday, February 3, 2016 2:28 PM
  • miguelh,

    The secondary replica is read-only?

    The secondary replica is configured in synchronous or asynchronous commit?


    Felipe Lauffer MCSA: SQL Server | MCP

    Wednesday, February 3, 2016 2:35 PM
  • It is asynchronous commit.

    Thanks.

    Wednesday, February 3, 2016 7:35 PM
  • Actually, the database is not moving.

    The secondary replica box is being moved to another physical location.

    Wednesday, February 3, 2016 7:37 PM
  • Hi miguelh,

    You don't have to shut down the secondary replica before move it.

    As mentioned in your another thread, you will move one of two secondary replicas of an AlwaysOn group to another physical location and the server will have a different subnet.

    And I have suggested you firstly remove the secondary replica from your AlwaysOn availability group following the instructions in this  article. Besides, take backup of all the databases on your secondary replica in advance and make sure that no applications connect to the secondary replica if you persist to shut down it.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support



    Thursday, February 4, 2016 8:20 AM