Finding recovery model type for all sql databases in a server.
SELECT NAME AS [Database Name] ,recovery_model_desc AS [Recovery Model] FROM sys.databases GO
