title: Database taking up way more space than tables combined
body: <p>I have a database that's taking up nearly 7 gigs.  If I look at the table usage, it should be much less than that, like 40 megs.  There was a large log table that I deleted yesterday, but my database still says it's very large.</p>
  
  <p>Here are the stats:</p>
  
  <pre><code>database_name   database_size   unallocated space
  Umbraco_Indoorpower 6911.56 MB  859.59 MB
  
  reserved    data    index_size  unused
  31144 KB    26272 KB    3240 KB 1632 KB
  </code></pre>
  
  <p>I ran this:</p>
  
  <pre><code>DBCC SHRINKDATABASE (umbraco_indoorpower, 99);
  </code></pre>
  
  <p>And that got my database down to 2.3 gigs.  Still though, way too large.</p>
  
  <pre><code>database_name   database_size   unallocated space
  Umbraco_Indoorpower 2302.44 MB  1.63 MB
  
  reserved    data    index_size  unused
  30016 KB    26200 KB    3240 KB 576 KB
  </code></pre>
  
  <p>I'm guessing I'm not freeing up all the space from that log table that I deleted yesterday.  I actual ran <code>delete from tblLog</code>.  Maybe that was the wrong way to go about it.</p>
  
  <p>Does anyone know how I can free up some more space?</p>