title: SQL Server 2005 transaction log is always too big
body: <p>I've read other posts and have done hours of research but am still none the wiser.
  I have a database that is 65 gig in the data file, and currently 230 gig in the log file. I'm trying to redesign the database so it is more efficient but when making schema changes, the log file tries to grow too large and the windows whinges that it's out of disk space. </p>
  
  <p>I've tried to shrink the file and the lowest it goes is ~220 gig. using DBCC OPENTRAN I can see there are no active transactions. using select * FROM sys.dm_tran_database_transactions I can see that there is nothing interesting going on.</p>
  
  <p>My interpretation of what I have read is that the log file should only be large if there is an active transaction and once all transactions are committed, the file should be able to be shrunk to theoretically something very small. correct? </p>
  
  <p>I've tried backup log with truncate_only followed by dbcc shrinkfile (dbname, 2)</p>
  
  <p>What can I do to shrink this file to something more manageable?</p>