title: SQL server - Delete statement increase the LOG size
body: <p>I have a <code>LOGGIN</code> database and it is quite big - 400 GB. It has millions of rows. </p>
  
  <p>I just ran a <code>delete</code> statement which took 2.5 hours and deleted probably millions of rows. </p>
  
  <pre><code> delete FROM [DB].[dbo].[table]
   where [Level] not in ('info','error')
  </code></pre>
  
  <p>This is a simple recovery model database. But when I ran the above statement the log files grew to be 800 GB and crashed the server. Why does the LOG file grows for a simple recovery model database?</p>
  
  <p>How can I avoid this in future?</p>
  
  <p>Thanks for your time - RM</p>