On System Center Virtual Machine Manager (SCVMM) 2008 or SCVMM 2008 R2, duplicate virtual machines (VMs) may appear in the SCVMM Administrator Console. In this scenario, one of the duplicate VMs has a Missing status, and the other VM has a different status.
If you try to delete the missing virtual machine, you may receive the following error message:
Error (802) The VM file vmname.domain.local is already being used by another VM.
To resolve this issue, follow these steps:
Close the SCVMM Administrator Console.
Stop the SCVMM service (VMMService.exe) on the SCVMM server.
Make a full backup of the SCVMM database.
Install Microsoft SQL Management Studio Express on the computer that has the SCVMM database.
Run SQL Server Management Studio Express, select the SCVMM database, and then run the SQL script that is documented on the following TechNet website: