Reset vCenter SQL Database

[jshah631]

Hello, we had vCenter SQL maintenance jobs disabled for a while which caused DB to grow very large and unmanagable. We want to start with a clean DB. How can we do that?

[4nd7]

Hello,

Please check this kb: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100012...

[vLarus]

This KB should help you : http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=102591...

This is a KB to help you purge the database.

And for shameless self promotion you can check out my blog http://vmice.wordpress.com/2012/04/21/vcenter-sql-database-troubleshooting/

where there are instructions how to shrink, truncate, defrag a vCenter SQL database.

Godd luck.