Limitations and Recommendations

operators

#tsql#operators

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.

For information about alternative ways to drop an availability group, see

Remove an Availability

Group (SQL Server).

syntaxsql

group_name

Specifies the name of the availability group to be dropped.

Executing

requires that the Always On Availability Groups

feature is enabled on the server instance. For more information, see

Enable and Disable

Always On Availability Groups (SQL Server).

）

Important

If possible, remove the availability group only while connected to the server instance that

hosts the primary replica. When the availability group is dropped from the primary replica,

changes are allowed in the former primary databases (without high availability protection).

Deleting an availability group from a secondary replica leaves the primary replica in the

state, and changes are not allowed on the databases.

DROP
AVAILABILITY
GROUP group_name
[ ; ]