pmp v5 database 2gb, log files 5gb

[Rogier Boeken]

hi

i use hp sim 5.3 sp1 with pmp 5.2.1 and monitor 4 servers (for pmp)

i noticed that my pmp database has grown to nearly 2gb and the log file is currently 5gb

i use sql expres 2005. I confess i do not know much about sql and am wondering if a) hp sim / pmp does not have a build in clean up schedule of the transaction log files it creates (for instance my blackberry server does this automatically, the script is part of the setup)

but more importantly does anyone know how to keep the size down of the database and log files and i how i can reduce the size of these files as my server is starting to run out of diskspace

i don't really use pmp anymore so i could easily uninstall it and remove the sql files and reinstall it at some stage

many thanks for your help

[Rogier Boeken]

apologies, i use sql 2005 server and not express

[kev001]

I would also be interested in an answer to this question. Our log file has reached 10gb, why does the database not comit the log files into the DB?