Database recovery model

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  January 6, 2006 at 2:15 pm

  #170476

  Hi,

  Tried to find Database Recovery Model in Properties, Options in SSMS 2005, but could not find it anywhere. They have whole lot of new properties and options there, but no recovery model. Did they moved it somewhere?

  Thanks

   

• david russell-253790

  SSCarpal Tunnel

  Points: 4042

  More actions

  January 6, 2006 at 3:16 pm

  #613401

  in SSMS, Right click on the DB, DB Properties, options, Recovery Model

  ---

  Cheers,

  david russell
  

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  January 9, 2006 at 8:23 am

  #613584

  If you just want to see what recovery model the DB is running in you can simply issue the following command -

  exec sp_helpdb db_name

  besides other DB information - it will list the Recovery Model.