USE [master]
GO
-- FULL Recovery Model
ALTER DATABASE [Database_Name] SET RECOVERY FULL WITH NO_WAIT
GO
-- SIMPLE Recovery Model
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
GO
-- Bulk Logged Recovery Model
ALTER DATABASE [Database_Name] SET RECOVERY BULK_LOGGED WITH NO_WAIT
GO