Check Recovery Model for a DB

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  June 27, 2006 at 7:37 am

  #191117

  What is an easy way to check the recovery model being used for a Database without SS Management Studio.

   

  Thank you

  Best Regards,

  ~David

• peterhe

  SSChampion

  Points: 11469

  More actions

  June 27, 2006 at 7:59 am

  #646061

  select

  database_id,name as database_name,recovery_model, recovery_model_desc FROM sys.databases