What can be clean up to reduce size of HPSIM's SQL DB?

[Jaime_39]

Anyone knows what can be clean up to reduce the HPSIM's SQL DB?
Just found out that there is daily backup of the transaction logs. Each daily transaction log is abt 300 to 400MB, at times can go up to 1GB a day.
When I compared this to others, their daily transaction log is only 2MB the most.
How I can reduce or clean up to reduce the transaction log?

[James Kennedy_4]

Change the database to Simple and check the box for Auto-Shrink. Should keep things about 2 MB. It's much happier.

[Jaime_39]

Thanks!