Set all databases to simple recovery.sql

-- Set all databases to simple recovery
-- Part of the SQL Server DBA Toolbox at https://github.com/DavidSchanzer/Sql-Server-DBA-Toolbox
-- This script generates SQL to set the Recovery Model to Simple for all databases

SELECT name AS DatabaseName,
       recovery_model_desc AS RecoveryModel,
       'ALTER DATABASE [' + name + '] SET RECOVERY SIMPLE;' AS SQL
FROM sys.databases
WHERE recovery_model_desc <> 'SIMPLE';