title: Is it ok to change from full recovery to simple recovery in Sql Server
body: <p>I have an old database - a users membership/role that was setup automatically by an ASP.Net 2 application years ago:</p>
  
  <p><img src="https://i.stack.imgur.com/PSY6O.jpg" alt="enter image description here"></p>
  
  <p>The Sql Server version currently running is: Sql Server 10.5.1617</p>
  
  <p>The users database log file is huge (the ldf file is approx 400 times the size of the mdf file).</p>
  
  <p>The recovery model is currently set to "Full". I understand what that is - and I don't need point in time restoration.</p>
  
  <p>If I simply changed the recovery model to "Simple" from within Sql Server Management Studio:
  <img src="https://i.stack.imgur.com/CBYTZ.jpg" alt="enter image description here"></p>
  
  <p>...and clicked ok to save the changes - would I be risking my current database in any way?  Or is Sql Server fine with making changes like this to live databases?  And would the log file automatically shrink itself?</p>
  
  <p>Thanks for your advice,</p>
  
  <p>Mark</p>