I have been trying to run some maintenance on the vcenter Database which has grown too large (10GB) on SQL Express.
I found that it was the VPX_TEXT_ARRAY that is over 6GB in size by running the script here:
so I tried to run through this VMware KB:
I got to step 6 where you delete the records of which I had 1444345 rows to delete! It was at this point that SQL said that the database transaction log was full:
"The transaction log for the database 'VIM_VCDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
The database has approximately 160MB free space but when I launch vcenter it shows all VM's as orphaned and that it can't contact the host servers, even though the hosts and VM's are fine if I login to them directly in vsphere?
I need help in sorting the vcenter Database size and therfore hopefully restoring vcenter connection to the hosts.
I am not a SQL admin and have only been following the KB's articles
We have 40 VM's/replicas over three hosts