https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091238#M49874 Hi Rob,<BR />it's the solution I've adopted .<BR />thanks for your help<BR />Stefano<BR /> Thu, 07 Feb 2008 07:01:29 GMT stefano colombo_1 2008-02-07T07:01:29Z https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091236#M49872 Hi ,<BR /> I've the following problem.<BR /> I'm using HPSIM with VMM and it's a couple of day that I find vmm filling up the transaction log.<BR /> I wonder what can be to produce so much data in sql related to vmm , and how to reduce them .<BR /> Thanks<BR /> Wed, 06 Feb 2008 07:49:03 GMT https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091236#M49872 stefano colombo_1 2008-02-06T07:49:03Z https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091237#M49873 You can set the Recovery model to Simple and then shrink the database.<BR />This should stop the log from growing, and you don't really need the Full Recovery model for the database. Wed, 06 Feb 2008 19:54:05 GMT https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091237#M49873 Rob Buxton 2008-02-06T19:54:05Z https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091238#M49874 Hi Rob,<BR />it's the solution I've adopted .<BR />thanks for your help<BR />Stefano<BR /> Thu, 07 Feb 2008 07:01:29 GMT https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091238#M49874 stefano colombo_1 2008-02-07T07:01:29Z https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091239#M49875 set recovery mode to simple Thu, 07 Feb 2008 07:14:31 GMT https://community.hpe.com/t5/server-management-systems/vmm-filling-sql-transaction-log/m-p/5091239#M49875 stefano colombo_1 2008-02-07T07:14:31Z