title: Can't shrink my SQL Server 2008 Log files - 260GB currently
body: <p>My database log files have grown to 260GB and I need to shrink them. I have tried numerous scripts such as:</p>
  
  <pre><code>DBCC SHRINKFILE ('HM_Log', 0)
  </code></pre>
  
  <p>As well as using the Shrink option in SQL Server Management Studio however the log file doesn't seem to shrink.</p>
  
  <p>Has anyone got any suggestions?</p>
  
  <p>The database is on my production server and actively used, I also have a maintenance plan setup to run all the relevant tasks including a daily transaction log backup and a weekly full backup which appears to be working fine.</p>
  
  <p>I need to shrink it down so I can do a full backup + restore on my local development machine, however at the moment the log files is too large for my local drive.</p>