Check Recovery Model of Databases

--Simple Script:

SELECT name as [Database Name] ,recovery_model_desc as [Recovery Model] FROM sys.databases
GO

--Built-in Function:

DECLARE @DB varchar(10);
SET @DB = 'TESTDB';
SELECT @DB as [Database Name],DATABASEPROPERTYEX(@DB,'recovery') as [Recovery Model]
GO

-- TO find recovery model of 'n' No. of database:

select [Name], DATABASEPROPERTYEX([Name],'recovery') as [Recovery Model]
from sysdatabases
where name in ('master','tempdb','SQLPracticeDB','TESTDB')

--Find recovery model and filter them with 'SIMPLE' recovery model.

select [Name], DATABASEPROPERTYEX([Name],'recovery') as [Recovery Model]
from sysdatabases
where DATABASEPROPERTYEX([Name],'recovery') = 'SIMPLE'