I noticed that the tranction log database is getting bigger than normal. How can i find out what is going on that why there are big transactions. I have a database maintenance plan that every 30 min. it dumps the log to a file and i see that the files are like 500MB before they used to be like 2mb.

thanks

Could be that, sometimes when the transactions were kept on retrying due to locking of rows based on the conditions, whenever attempted details logged, it might grow...

If you check-up the log file, if there are more entries only for particular table, then it might be causing due to erraneous program looping statement...just double check them.