Changing SQL Server 2008 recovery mode

Question

Does anyone have t-sql to change the recovery mode of a database to simple?

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.

Answer 1

ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT

Answer 2

use [database_name]
alter database  [database_name]
set recovery simple