Never before seen entries in Log file
-
Has anyone ever seen the 4 entries below in a SQL log file? I have searched for answers but found nothing. Should I worry - the database in question is working. The first 3 entries were listed in the log right after the log file was reinitialized.
Before: LogRecs= 2291 Used= 251000, Rsvd= 188787, SysUsed= 21172
After: LogRecs= 4588 Used= 434628, Rsvd= 0, SysUsed= 21172
Short= 8623, ShortComp= -5159, TotalUsed= 455800, Short%=-1.1
2003-02-03 08:50:43.74 spid293 Log space info for tran 0:14928939 in database 9
Thanks in advance for your input
Karen
-
I guess no one has ever seen this - I got another one yesterday. I hope this isnt a arning tome re: a problem - I found no info on this on any web site/forum. Here is the error I rec'd yesterday
2003-02-04 09:18:05.54 spid37 Log space info for tran 0:14971699 in database 9
Before: LogRecs= 1582 Used= 173344, Rsvd= 127707, SysUsed= 0
After: LogRecs= 3174 Used= 300540, Rsvd= 0, SysUsed= 0
Short= 9041, ShortComp= -511, TotalUsed= 300540, Short%=-0.2
-
Looks like it may be related to some sort of cleanup for a transaction.
Where you able to find in similarities in server activity at the time of the two messages?
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
-
Or after a shrink or expand happens?
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply