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: 
```
ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT

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

```