If the primary node in your database high availability cluster fails and you promote a new primary, you must unregister the failed primary node to remove it from the cluster and avoid inconsistent cluster status data.
Prerequisites
- To unregister a primary node that is not running, you must provide the node ID. To find the IP address, check the status of the cluster and locate the node. On that row, use the host value from the Connection string column to identify the IP address of the node. See Check the Status of a Database High Availability Cluster.
- Verify that the failed primary is inactive and without any following standby nodes, and promote a new primary.