2nd SQL Log on SIM server fills up

[RHagen_1]

So I've got this SIM 4.2sp2 server with a SQL log file on the server that keeps filling up... None of the typical responses like setting the DB to simple, daily backups and autoshrinking enabled seems to be making any changes. This is not the typical SQL log on the remote SQL server, This seems to be more like a transaction log..but on the SIM server. when I delete it, the system recreates the log and starts fill it up again...

[Igor Karasik]

Ralph, what exactly name and full path of the file? Maybe name is not SQL.log as you wrote in http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=965481 ?

[Igor Karasik]

Maybe you mean MX.log file - audit log of HPSIM?
If yes: see
"HP Systems Insight Manager 4.2 May Record Repeated Error Messages in MX.LOG if Custom Commands Run with the Run Now Button Then Deleted"
http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000080430635
You can also configure max size of this file
http://docs.hp.com/en/5991-0710/ch14s03.html

[RHagen_1]

SQL.Log ...This is why it's been so confusing to reponses... our SQL DB says there seems to be two files named SQL.log..one on the remote sql server that is doing exactly as predicted (grows, shrinks, etc).. but this SQL.log file on the SIM server doesn't correspond to any named transaction log in the SIM documentation. it just keeps growing....it's on a seperate drive name logs (we'll call it "L"). So this file is at the root of L.. another problem.. I don't know were it orginated or where it would have gone by default..