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.
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