jshah631
Contributor
Contributor

Reset vCenter SQL Database

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?

0 Kudos
2 Replies
4nd7
Enthusiast
Enthusiast

0 Kudos
vLarus
Enthusiast
Enthusiast

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 Smiley Happy 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.

vmice.net
0 Kudos