title: Why can't I shrink a transaction log file, even after backup?
body: <p>I have a database that has a 28gig transaction log file.  Recovery mode is simple.  I just took a full backup of the database, and then ran both:</p>
  
  <p><code>
  backup log dbmcms with truncate_only</p>
  
  <p>DBCC SHRINKFILE ('Wxlog0', TRUNCATEONLY)
  </code></p>
  
  <p>The name of the db is db_mcms and the name of the transaction log file is Wxlog0.  </p>
  
  <p>Neither has helped.  I'm not sure what to do next.</p>