.::: How to remove and add replica, database, listener on AlwaysOn MSSQL Server :::.

SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.

1. Avaibility Databases
Remove >>Availability Databases >> Remove Database From Availability Group

Add Availability Databases >> Add Database

>> harus pakai sql server didalamnya atau bisa join domainnya (Server must joined domain)
>> database standby harus kosong (Full) atau Database ready restore (joint only) <full or join only>

2. Availibility Replicas
remove  >> langsung Availability Replicas >> Remove from Availability Group

Add Replicas >> 
Availability Replicas >> Add Replica
>> harus pakai sql server didalamnya atau bisa join domainnya (Server must joined domain)
>> database standby harus kosong (Full) atau Database ready restore (joint only) <full or join only>

3. Avaibility Group Listeners
remove >> langsung remove avaibility (group listener)

add listener
Availability Group Listeners >> Add Listener