Transaction log unexplained growth

[tmp14]

I have 3 (SQL 7.0) databases that are experiencing unreasonable transaction log file growth. Originally the database was set up 2GB data and 1GB log. Curently the log is 14GB. I have tried truncating the log, checking for open transactions and running various DBCC commands. The truncate worked on one of the databases but not the other 2 (which of course are the more critical).

 

[tlbroadbent]

Check these links for help in shrinking logs.

faq183-345

http://support.microsoft.com/support/kb/articles/q256/6/50.asp?

http://www.swynk.com/friends/krishnan/tranlogshrink.asp

http://www.mssqlserver.com/faq/logs-shrinklog.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.