Transaction Logs for SMS

[freeland]

We are having some troubles with the transaction logs for SMS. The logs just keep growing and growing, we dump them and they just start growing again. We have put a 500 meg limit on it cause it keeps growing. It will reach 500 meg's in about 2 hours. We have changed nothing on the SMS server and before it was just set to 50 megs of space and we never got errors at all. Any information will great be appreciated.

 

[snyderj]

Are all the logs growing or just certain ones? Which ones? Server or client or both? Are there any common messages being repeated in any of the logs? Does everything else seem to be working fine?

 

[freeland]

We found that 2 of our collections were the cause of the problem. One was set to update every 1 min and the other was set to update every 1 hour. We used a program called Lumigent Log Explorer that shows the logs in real time. It showed us what was going on, it was updating all the time not giving time for the logs to truncate, so it just kept growing none stop due to the excessive record writes. Thank for the info above that pointed us in the right direction.