title: How do I shrink the transaction log on MS SQL 2000 databases?
body: <p>I have several databases where the transaction log (.LDF) is many times larger than the database file (.MDF).</p>
  
  <p>What can I do to automatically shrink these or keep them from getting so large?</p>