why is my vc database so big ?

[GarethWilson]

Hi

I have a VC server running Windows 2008 and SQL 2008 and vsphere 4.1, we have 15 hosts spread over 3 clusters (running 4.1) and about 200 vm's, looking at the database sizing tools from vmware my db should be about 5-7gb in size but it is currently 35gb in size and growing ?

anyone got any ideas why its so big ?

Cheers in advance

[Troy_Clavell]

check your transaction logs. I also suggest, if not already there, going from full recovery mode, to simple

Here are a few pointers

http://kb.vmware.com/kb/1003980

http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf

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

[GarethWilson]

cheers for the promt reply i will go through the kb's and post back with more info

Thanks again

PS the trans log is 16gb

[maxel]

If you do not backup your transaction log files ..your DB will grow..and grow.. and grow...