Skip to content

A vSphere installation mistake you will only make once….

January 24, 2013

Lets imagine you have performed a fairly standard installation of an ESXi/vSphere environment.  Did you make any changes on this screen?

vcenter databse retention policy


If you answered “No” to this let me tell you what is going to happen….your vCenter database is going to store all information regarding tasks and events forever.  Your database will grow and grow until it reaches the limit on the database size for your version of SQL or until you run out of disk space.  Then the vCenter service will shut down and you won’t be able to start it up.

This happened to one of my clients, vCenter was installed using the SQL Express version and hit the 4GB limit on the database size.

Now what?

Go here and you will find a script you can run to clear out the database.  Now you can shrink the DB and finally start the vCenter service.

Now remember to go back and put a tick in your boxes!  The numbers you choose are down to you but for me 365 is plenty, the default is 180 days or 6 months.

Now remember to go back to every vCenter server you have ever installed and make the change!




Leave a Comment

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: