I would try specifying a new file name in the Tracing area of the ODBC
Control Panel toy. After a reboot - or, at the very least, a quick toggle
of the Start Tracing button - the new file should become locked and (I would
hope) the old one should be released.
Incidentally, unless this server is some kind of firewall/proxy or IP router
for your customers, this SQL blob shouldn't be impacting anyone's
experiences with the outside world. I would, however, expect problems with
services that run on the machine with the immense log. For instance, if you
have a mail daemon running there, chances are it will have some serious
problems if you run out of disk space. :-)
David V. Brenner - email@example.com
International Services Network Corporation
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf Of Patti Raatz
> Sent: Wednesday, August 11, 1999 11:26 PM
> To: Emerald List
> Subject: [Emerald] I'm in Trouble
> I'm not sure what is going on...maybe someone here can help me.
> Quite suddenly today, many of my customers could not navigate the
> web. Had
> them ping and received time out error messages, had them
> traceroute and they
> get an error message (that my blonde brain can't remember at the
> moment and
> I didn't write it down...duh).
> So I started looking through my hard drive after calling my upstream and
> being told they couldn't find a problem.
> What I found was a notepad file (named sql.log) that was 1.39GB in size!
> Looking at the properties told me the file was created 7/7/99 at 10:54 PM
> (the latest I stay at the office is 10:30PM and on Wed nights I was
> I've tried to open the file and lock up the server tight! I've tried to
> delete the file and told I can't because of a sharing violation!
> I have recovered some of my drive space by compressing the file but at the
> rate it is growing, I fear for my system and my customers loss of
> understanding. I don't know where this file came from, what it
> is doing, or
> how to get rid of it....any suggestions?
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: