Ciscoworks2K SQL Log File

Unanswered Question
Feb 23rd, 2007


I have a CW2K server installed and working fine, but I have noticed that a SQL.LOG file is increasing continually until there is not space in the hard disk of the server. Is this a normal situation or there is a problem in my CW2K server?? Please if anybody can help me.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Joe Clarke Fri, 02/23/2007 - 13:48

Exactly which CiscoWorks bundle do you have, and where is this SQL.LOG located? I know of no such file used by LAN Management Solution.

aparada14 Fri, 02/23/2007 - 14:13


This is a Ciscoworks 2000, I think it?s LMS 2.1 (old software) and the Log file is located in the main Drive (C:) or the default directory where is installed CW2K (C:\program files\CSCOpx\)


Joe Clarke Fri, 02/23/2007 - 20:35

What are some of the contents of this file? I do not recall a mandatory SQL.LOG file even in the older version of LMS.

aparada14 Mon, 02/26/2007 - 05:52


The file log size until now is about 3Gb, and some lines containing this file are in the file text attached.


David Stanford Mon, 02/26/2007 - 07:23

Do you have an external program that is trying to perform direct queries on the RME database?

I haven't seen any sql.log in any version of LMS and from the output in you file it looks like you have a program that may be querying the LMS databases.

Joe Clarke Mon, 02/26/2007 - 09:06

Go to Administrative Tools > Data Sources (ODBC) in Windows, and select the Tracing tab. Stop tracing, then you can safely delete this file.


This Discussion