Wich table holds the info about the recovery model?

• nelson.viggiani

  SSC Enthusiast

  Points: 152

  More actions

  June 5, 2008 at 6:36 am

  #187622

  Using sql 2000 witch table holds the info about the recovery model?

  I coulnd't find it on sysdatabases

  I know on sql 2005 is in sys.databases

  any ideas?

  thanks

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 5, 2008 at 6:50 am

  #824755

  SELECT DATABASEPROPERTYEX(N'DatabaseName', N'RECOVERY')

• nelson.viggiani

  SSC Enthusiast

  Points: 152

  More actions

  June 5, 2008 at 6:53 am

  #824759

  thank you