I'm wanting to know, if I remove a VM from the inventory, what happens at the DB level? Are the records (tasks/events I'm concerned about) purged or retained under some other unique ID? As I've noticed that when you re-add to the inventory the records aren't accessible via the client.
We've had an issue recently with backup jobs of a few VMs spamming the task/event log with 'map disk region' and filling the VC database. So I'm hoping that removing said VMs from inventory and adding back in will release said space so we can then do a shrinkdb.
Can anyone confirm as I can't find any documentation to suggest what happens to the DB records.
Any event performed on the vCenter with be recorded, even with the actual VM being removed from vCenter Inventory.
the below links to purge the vpx_event tables in DB, which keen the events can be used.
clearing the events does not have any impact on the Actual working of vCenter. it only clears old events.
I would also suggest you to fix the Backup issues which is resulting in huge event creations.