title: How To Optimize Sql Server Database with Huge Log File
body: <p>I've a sql server database sized 1677,25 MB. Here's my detailed DB size info:</p>
  
  <p>DB Size:1677.25 MB<br>
  Unallocated space: 343.09 MB</p>
  
  <p>Reserved: 24488 KB
  Data: 18560 KB
  Index size: 2632 KB
  Unused: 3296 KB
  Row Count: 74410</p>
  
  <p>So, as you can see it's not that big DB. The issue is, logs. </p>
  
  <p>Log file's size is: 1.311 GB</p>
  
  <p>How can I clean the old logs? Ok maybe last 3 month's important but 1.3 GB is really an important size.</p>