I had an issue with SCVMM today that was new where with trying to remove a host cluster on of the Hosts became stuck in a pending state and would not finish the process of removing itself. The agent removed itself from the host correctly, but the entry within VMM would not.
After trying a more an more common task of modifying the host status within VMM database with SQL Management Studio without luck, I came across Chris’s Blog who had the solution to the same problem and I wanted to highlight his work.
After a bit of VMM database surgery, the Host entry was cleaned up perfectly and all is now stable and working perfectly. Thanks Chris.
Go HERE for the detail of this solution.