Symptoms:
- Cannot upgrade vCenter Server database to versions 5.1 or 5.5
- Upgrading vCenter Server database to versions 5.1 or 5.5 fails with the error:
Failed to execute command: DROP INDEX VPX_VDEVICE_FILE_BACKING_U1 ON VPX_VDEVICE_FILE_BACKING
- In the %temp%/VCDatabaseUpgrade.log file, you see entries similar to:
Error: Failed to execute command: DROP INDEX VPX_VDEVICE_FILE_BACKING_U1 ON VPX_VDEVICE_FILE_BACKING;Got exception: ERROR [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the index 'VPX_VDEVICE_FILE_BACKING.VPX_VDEVICE_FILE_BACKING_U1', because it does not exist or you do not have permission. Error while upgrading: ERROR [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the index 'VPX_VDEVICE_FILE_BACKING.VPX_VDEVICE_FILE_BACKING_U1', because it does not exist or you do not have permission.
Info: Exiting Upgrade Wizard
Successfully run: alter database [VIM_VCDB] set recovery FULL
Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.