title: free space after truncate table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6158324/reclaim-space-in-sql-server-2005-database-when-dropping-tables-permanently">Reclaim space in SQL Server 2005 database when dropping tables permanently</a>  </p>
  </blockquote>
  
  
  
  <p>I had a table which took 20GB and it is not needed, but using DELETE statement was not an option since it would cause the LDF file to grow rapidly due to the logging of each row entry deleted.</p>
  
  <p>So I've used TRUNCATE TABLE, though now the db still takes the same amount of space although I've deleted this table. I've read somewhere that I should use shrink database option, but the problem is they say it should delete all indexes in the database?</p>
  
  <p>What would you recommend doing? Is there other way to free this unallocated space from the MDF file?</p>
  
  <p>Thanks</p>