Server Management - Systems Insight Manager
1833752 Members
2683 Online
110063 Solutions
New Discussion

Re: vmm filling SQL transaction log

 
SOLVED
Go to solution
stefano colombo_1
Super Advisor

vmm filling SQL transaction log

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
3 REPLIES 3
Rob Buxton
Honored Contributor
Solution

Re: vmm filling SQL transaction log

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
Super Advisor

Re: vmm filling SQL transaction log

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

Re: vmm filling SQL transaction log

set recovery mode to simple