I use VM-Ware vSphere 5.5, vCenter 5.5 and MS.SQL 2008
Express.
The problem is the Database Log is full and I already solve
this problem as following;
Purging old data from the database used by vCenter Server
https://kb.vmware.com/s/article/1025914 but
is still cannot solve it so I have a question as below.
1. After the Purge has been restored, we get available space
at 10-15 MB. Is there another method to get more space?
2. From the table of the database as attached picture, which
column, row or data that I can delete in order to get more space? please kindly
advice.
You can get rid of VPX_EVENT which contains the VIEvents details, also VPX_HIST_STAT4 contains the performance data, which can be cleaned up as per VMware Knowledge Base, if not required.
Event and stat4 table are "penuts".
Take a look to VMware Knowledge Base how to decrease the size of the VPX_TEXT_ARRAY table.
Regards,
Joerg