Post reply

Always on

  • January 27, 2015 at 4:01 am

    #294268

    how to remove always on in sql 2012 ?

  • January 27, 2015 at 8:17 am

    #1773395

    do you intend to remove the primary and all secondarys?

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

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

  • January 27, 2015 at 9:54 pm

    #1773561

    Yes ..

  • January 28, 2015 at 4:21 am

    #1773627

    remove any secondary databases from the availability group by;

    • connected to the primary using the GUI and selecting the required database under "Availability databases". Then under the AO group, right click selecting "Remove secondary database".

      You may then either bring the secondarys online or just delete them with

      drop database [yourdb]

    • Via TSQL on the primary use

      ALTER AVAILABILITY GROUP yourAGgroup REMOVE DATABASE yourhadb

      Again bring them online or just delete them using drop database

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

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

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

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