How to delete missing VM in SCVMM 2008 or SCVMM 2008 R2

Microsoft published a new System Center Virtual Machine Manager 2008 solution; "The issue is one where on SCVMM 2008 or 2008 R2, duplicate VMs may appear in 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 […]

Microsoft published a new System Center Virtual Machine Manager 2008 solution; "The issue is one where on SCVMM 2008 or 2008 R2, duplicate VMs may appear in 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 missing VM, you may receive: Error (802) – The VM file vmname.domain.local is already being used by another VM," explains Microsoft in KB983839.

To resolve: Close SCVMM Admin Console; Stop SCVMM service (VMMService.exe) on SCVMM server; Make full backup of SCVMM database; Install Microsoft SQL Management Studio Express on computer that has SCVMM database; Run SQL Server Management Studio Express, select SCVMM database, and then run SQL script; This script deletes all missing VMs that've a Missing status from SCVMM database; If script was successful, you see following output: Commands(s) completed successfully. After script has finished, restart SCVMM service (VMMService.exe) on SCVMM server, and then open SCVMM Administrator Console to verify that missing VMs were deleted.

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.