Help my vcenter 5.0.0 ,455964 windows server version has reached the 4gb size and shrinking did not resolve the issue.
Please what more can i do if i am not ready for an upgrade to standard or enterprise sql database.
As a fist step (after backing up the database of course) follow step 1 to 6 from VMware KB: Troubleshooting VPX_HIST_STAT table sizes in VMware vCenter Server 5.x to get an overview of the table sizes. I'd suggest you remove "where NAME like '%VPX_HIST_STAT1%'" from the SELECT clause to see all tables.
Depending on the table sizes, either search the VMware Knowledgeable for how to get rid of unnecessary data, or reply to this discussion and provide the results of the query.
i would recommend you to check this vmware's KB, it can be helpful:
According to the file you provided the largest tables are "VPX_HIST_STAT2" and "VPX_TEXT_ARRAY" . So what you can do - after backing up the database of course - is to follow the KB article I provided earlier for "VPX_HIST_STAT2", and http://kb.vmware.com/kb/2005333 for "VPX_TEXT_ARRAY".
The last time I needed to run the Delete command for the "VPX_TEXT_ARRAY" table, I had to set the database's log file to unrestricted growth, because the default size limit was not sufficient for the transaction.