Categories
Software Technical

Purging old data from the database used by VirtualCenter 2.x (a repost)

VirtualCenter stores tasks, event, and performance data in the VirtualCenter database. Over time, data collection results in growth of the database files and a mechanism is needed to shrink these files.

VirtualCenter 2.x does not have a feature to purge or shrink old records from the database. For more information on shrinking databases after running the scripts provided in this article, see:

Link 1: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1000125

Link 2: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1025914

 

How to Shrink a Database (http://msdn.microsoft.com/en-us/library/ms189035.aspx) & (http://msdn.microsoft.com/en-us/library/ms189080.aspx)