Post reply

impact delete AVAILABILITY GROUP

  • December 26, 2018 at 1:20 am

    #381097

    Hello everyone
    if I proceed to eliminate the Group avaibility through
    DROP AVAILABILITY GROUP AccountsAG
    Will the objects associated with my computer object listener in the active directory as well as the associated DNS record will also be deleted or I must manually remove it

  • December 26, 2018 at 4:25 am

    #2017313

    abdalah.mehdoini - Wednesday, December 26, 2018 1:20 AM

    Hello everyone
    if I proceed to eliminate the Group avaibility through
    DROP AVAILABILITY GROUP AccountsAG
    Will the objects associated with my computer object listener in the active directory as well as the associated DNS record will also be deleted or I must manually remove it

    Have a look 

    https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-availability-group-transact-sql?view=sql-server-2017

    Removes the specified availability group and all of its replicas. If a server instance that hosts one of the availability replicas is offline when you delete an availability group, after coming online, the server instance will drop the local availability replica. Dropping an availability group also deletes the associated availability group listener, if any.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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