Home Forums Article Discussions Article Discussions by Author Discuss content posted by alanw Quickly Reveal DB Recovery Model on all Databases. RE: Quickly Reveal DB Recovery Model on all Databases.

  • 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