https://community.hpe.com/t5/server-management-systems/sql-transaction-log-size-with-sim-4-1/m-p/3394714#M6511 We are running an installation of HP Systems Insight Manager on a Windows 2003 server, the database backend is Microsoft SQL 2000. There are currently 135 managed servers in Insight but this will be increased to ~300.<BR /><BR />The database itself is quite small (130Mb) but the transaction logs are growing at a impressive rate (~12Gb Per Day), the database is set to 'Full Recovery Model' and we are doing nightly backups of the logs with trasaction log truncation switched on which is working well.<BR /><BR />Does anyone have any idea why the transaction logs are growing so fast and how I can slow it down. It is not currently an issue but if the backups fail or we add more managed server I can see it growing at a crazy rate, this is when it will become an issue for me.<BR /><BR />Thanks in advance<BR />Regards<BR />Matthew<BR /><BR /><BR /> Wed, 06 Oct 2004 11:02:17 GMT Matthew Hartley 2004-10-06T11:02:17Z https://community.hpe.com/t5/server-management-systems/sql-transaction-log-size-with-sim-4-1/m-p/3394714#M6511 We are running an installation of HP Systems Insight Manager on a Windows 2003 server, the database backend is Microsoft SQL 2000. There are currently 135 managed servers in Insight but this will be increased to ~300.<BR /><BR />The database itself is quite small (130Mb) but the transaction logs are growing at a impressive rate (~12Gb Per Day), the database is set to 'Full Recovery Model' and we are doing nightly backups of the logs with trasaction log truncation switched on which is working well.<BR /><BR />Does anyone have any idea why the transaction logs are growing so fast and how I can slow it down. It is not currently an issue but if the backups fail or we add more managed server I can see it growing at a crazy rate, this is when it will become an issue for me.<BR /><BR />Thanks in advance<BR />Regards<BR />Matthew<BR /><BR /><BR /> Wed, 06 Oct 2004 11:02:17 GMT https://community.hpe.com/t5/server-management-systems/sql-transaction-log-size-with-sim-4-1/m-p/3394714#M6511 Matthew Hartley 2004-10-06T11:02:17Z https://community.hpe.com/t5/server-management-systems/sql-transaction-log-size-with-sim-4-1/m-p/3394715#M6512 You should really consider changing the database recovery model to simple. The rapidly growing transaction log is a known issue with SIM. Wed, 06 Oct 2004 11:14:33 GMT https://community.hpe.com/t5/server-management-systems/sql-transaction-log-size-with-sim-4-1/m-p/3394715#M6512 Joel Rubenstein 2004-10-06T11:14:33Z