In some cases, the database of a vcenter server may be running. Most of the time, this is the Express edition of SQL Server 2008, which is limited to a database size of 10GB. Often, the reason for running the database is a value that is not set or too high for keeping the logs in the Vcenter server settings. In these cases, VMware refers to shrinking the database using SQL Management Studio, or Execute a stored procedure that deletes the event tasks from the database. However, there is also the possibility of this stored procedure without SQL Management Studio or Execute SQL know-how. To do this, simply open a Microsoft Eingabebeaufforderung on the vcenter server (run as Administrator) and enter the following commands:
sqlcmd-S LocalhostVIM_SQLEXP Use VIM_VCDB Go Changed database context to ´ VIM_VCDB ´. EXEC Cleanup_events_tasks_proc Go
Depending on the size of the database or Number of events, this process can take a few minutes to hours. The process is complete when the cursor in the Eingabebeaufforderung flashes again
Senior Consultant and Blogger from the beautiful Constance on Lake Constance. When I’m not in the middle of a data center, I advise clients in the IT infrastructure space. This includes storage, server, backup and cloud integration in IT infrastructures. In my free time I take care of my own garden where I grow my own fruit and vegetables.