SELECT name, recovery_model_desc FROM sys.databases