1. SELECT recovery_model,recovery_model_desc  

  2. FROM sys.databases  

  3. WHERE name =''