SQL Transaction Log Size with SIM 4.1

[Matthew Hartley]

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.

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.

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.

Thanks in advance
Regards
Matthew

[Joel Rubenstein]

You should really consider changing the database recovery model to simple. The rapidly growing transaction log is a known issue with SIM.