How do I shrink the transaction log on MS SQL 2000 databases? - Stack Overflow

Backup transaction log and shrink it. If the DB is being backed up regularly and truncated on checkpoint, it shouldn't grow out of control, however, if you are doing a large number (size) of transactions between those intervals, it will grow until the nex

stackoverflow.com