title: Changing SQL Server 2008 recovery mode
body: <p>Does anyone have t-sql to change the recovery mode of a database to simple?  </p>
  
  <p>We are changing our backup strategy so now I need to bulk change many databases from Full recovery mode and would prefer not to do this one at a time in SSMS.</p>