- If the DB has reached a 4GB limit in SQL express, if the DB is corrupted, or if vCenter is unavailable for any reason, purge the event and event_arg tables either by manually enabling the DB retention policy in the DB using SQL Studio, or by running the stored procedure to purge the data from these tables
- To enable the database retention policy for the events and tasks, Open table dbo.VPX_PARAMETER:
- Modify event.maxAge to a value in days.
- Modify event.maxAgeEnabled to value of true.
- Modify task.maxAge to a value in days.
- Modify task.maxAgeEnabled to a value of true
- Run the built in stored procedure: from the VCDB > Programmability > Stored Procedures > Right-Click dbo.cleanup_events_tasks_proc and click execute. This will purge the data from tables:vpx_event, vpx_event_arg and vpx_task based on the date specified for maxAgeFonte : VMware KB