How can I tell what recovery model my SQL database has?
Some variety in how to do it...

SELECT D.recovery_model_desc FROM sys.databases D WHERE name = 'MyDB'


or

SELECT name, D.recovery_model_desc FROM sys.databases D


or

SELECT DATABASEPROPERTYEX('MyDB', 'Recovery')