Another Day, Another SQL Express issue with VMware vCenter Database

As the title says – another issue with the vCenter Database becoming full on SQL Server

Go into the SQL Management Studio and navigate the vCenter Database

First check the Size of the DB – Right Click on the DB and select Properties – you see that the DB space available is too low

4

Now close this and stop the VMware vCenter Service

Select Programability > Stored Proceedures

At the bottom there is dbo.cleanup_events_tasks

Untitled picture

Run this query – in my case it took an hr or so to complete but i keep checking the size of the Database decreasing over this time

Start your vCenter Server Service again

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s