Quickly Reveal DB Recovery Model on all Databases.

• alanw

  SSC Enthusiast

  Points: 111

  More actions

  October 1, 2007 at 3:02 am

  #175402

  Comments posted to this topic are about the item Quickly Reveal DB Recovery Model on all Databases.

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  March 9, 2012 at 5:26 am

  #1457093

  Hi,

  Simpler scirpt :

  select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by name