Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 garbage in sql server log file

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-03-04 : 09:21:06
hi,
My database server had hung up recently, and I had to restart it.
After checking the sql server log I found some garbage entries in it.
has anyone encountered similar situation?
harshal.




He is a fool for five minutes who asks , but who does not ask remains a fool for life!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-04 : 12:19:53
It wouldn't be garbage. It's probably access violation information or memory dump information. It does mean something, just not to us.

Tara
Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-03-05 : 07:33:44
quote:
Originally posted by tduggan

It wouldn't be garbage. It's probably access violation information or memory dump information. It does mean something, just not to us.

Tara



So is it a usual behavior to have ascii code in the sql logs or something needs to be done ?


He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-05 : 16:11:41
I wouldn't say normal, but as long as the system has been checked and is working fine, you should be okay. If however you keep experiencing problems, then I would worry. Do you have sp3a installed?

Tara
Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-03-08 : 00:33:00
quote:
Originally posted by tduggan

I wouldn't say normal, but as long as the system has been checked and is working fine, you should be okay. If however you keep experiencing problems, then I would worry. Do you have sp3a installed?

Tara


yes sp3a is installed


He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page
   

- Advertisement -