Purging old data from the database used by vCentre Server 4.x (2.5 also included)
We had a failed VC today – seems our client managed to fill the SQL database and fill the storage.
It is a physical host, so expanding the disk is not so easy.
Time to clear the VC database up . .
Luckily, VMware have posted the how-to for this one (as they did before for 2.5)
The details are pretty thorough . . just watch out to make sure you stop your VC service before running this (and if you can, back up your database as you’ll be purging data from the database)
Note: Do not run the scripts attached to this article against a VirtualCenter 2.x database. For information about purging data in VirtualCenter 2.x, see