DRS anti-affinity groups and rules must be configured in on-premises vSphere Cluster to separate VMs hosting a SQL Server Always On workload. Creation of such rules is required to align with the supported cluster configuration on the vSphere platform and to avoid situations when both VMs will reside on a single host, creating a single point of failure. Migrating a VM with DRS overrides is not supported and will fail on attempt, returning the following error message:
A VM must be removed from all DRS rules and groups before migration. Once the workload is migrated, appropriate rules and groups must be re-created on the SDDC where the workload is now hosted. As a best practice, make sure the configured DRS rules and groups are documented before removing VMs.