Deleting a SQL Server AG virtual database
To delete the AG virtual database, navigate to the database from CLI and select the AG VDB to be deleted, then type delete, set the delete properties, and then click Commit.
For a full cleanup (includes deletion on the engine as well as host), attempt to delete without changing any parameters i.e.
force=false
The force parameter is set to false by default.
In the event, when a node of the Windows Server Failover Cluster (WSFC) cluster participating as an AG replica is currently unavailable, a user can choose to perform Force delete. Unlike delete, Force delete does not guarantee full cleanup. It only promises to perform cleanup on the engine and not on the cluster nodes.
Set the following parameter for Force delete -
set force=true
Force delete should only be chosen in cases when the user does not intend to use the cluster/nodes again for provisioning as the ghost VDB volumes can interfere with other Delphix operations without proper cleanup.