How to determine recovery model?

• Tom Goltl

  SSCertifiable

  Points: 5815

  More actions

  August 5, 2003 at 1:05 pm

  #159537

  What is the appropriate table/column to determine what recovery model is currently being used in a database. I need to do this in a query.

  Thanks Tom

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 5, 2003 at 1:26 pm

  #468714

  SELECT DATABASEPROPERTYEX('yourdbname', 'Recovery')

• Tom Goltl

  SSCertifiable

  Points: 5815

  More actions

  August 6, 2003 at 6:35 am

  #468787

  Thanks,

  It worked great.

  Tom