How To List Of Databases With Only Full | Simple| Bulk Logged Recovery Model
Script
SELECT name, DATABASEPROPERTYEX(name, 'Recovery') as Recovery_Model
FROM sys.databases
WHERE DATABASEPROPERTYEX(name, 'Recovery') = 'Full'
ORDER BY name;
Don't forget to subscribe to our channel.
/ tricksthatmakesmart
/ tricksthatmakeyousmart
/ tricksthatmakeyousmart