vmm filling SQL transaction log

[stefano colombo_1]

Hi ,
I've the following problem.
I'm using HPSIM with VMM and it's a couple of day that I find vmm filling up the transaction log.
I wonder what can be to produce so much data in sql related to vmm , and how to reduce them .
Thanks

[Rob Buxton · Accepted solution]

You can set the Recovery model to Simple and then shrink the database.
This should stop the log from growing, and you don't really need the Full Recovery model for the database.

[stefano colombo_1]

Hi Rob,
it's the solution I've adopted .
thanks for your help
Stefano

[stefano colombo_1]

set recovery mode to simple