Re: [Emerald] I'm in Trouble

Josh Hillman ( (no email) )
Thu, 12 Aug 1999 10:44:29 -0400

From: Patti Raatz <>
> Quite suddenly today, many of my customers could not navigate the web.
> them ping and received time out error messages, had them traceroute and
> get an error message (that my blonde brain can't remember at the moment
> 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
> teaching).
> 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,
> how to get rid of it....any suggestions?

Use a file utility such as "tail" to hopefully view the last few lines of
the original log file to find out what's going in there.
If you need the tail.exe utility, get it from Drop it into your winnt directory (so
that it's in the path), then open up a command prompt and type in
tail -f (whateverpath)\sql.log
Hit control-c to stop watching.
Stop SQL.
Rename the file.
Start SQL (this should create a new log file).

If there's nothing of any importance in the original log file, shift-delete
the file (using the shift key while deleting bypasses the recycle bin).


For more information about this list (including removal) go to: