VMware Cloud Community
natewilson
Contributor
Contributor

Cleaning SQL Express DB?

I have 2 lab environments, each running their own vCenter server with a local SQL Express DB. Although the environments are not very active, and don't need full SQL server, the DB eventually fills up and stops working. I guess it's probably filling with something like ESX performance data.

While making some other changes, I am wanting to get ahead of the game and 1) figure out how to clean the DB, and 2) to automate the cleaning, so maybe once a month it will clear unneeded data out.

Has anyone else already solved this issue? Any tips on what data can be dumped, and how to do that (are the needed tools included with SQL Express)?

Reply
0 Kudos
1 Reply
AndreTheGiant
Immortal
Immortal

Have a look at this KB:

http://kb.vmware.com/kb/1000125

Andre

Andre | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
Reply
0 Kudos