topic Re: 2nd SQL Log on SIM server fills up in Server Management - Systems Insight Manager

2nd SQL Log on SIM server fills up

RHagen_1 — Mon, 31 Oct 2005 19:55:36 GMT

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...

Re: 2nd SQL Log on SIM server fills up

Igor Karasik — Tue, 01 Nov 2005 05:16:03 GMT

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 ?

Re: 2nd SQL Log on SIM server fills up

Igor Karasik — Tue, 01 Nov 2005 05:25:33 GMT

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

Re: 2nd SQL Log on SIM server fills up

RHagen_1 — Tue, 01 Nov 2005 15:39:37 GMT

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..