How to Find SQL Databases in SIMPLE Recovery Model
January 23rd, 2009 by admin | No Comments | Filed in Database, DesignVery simpleā¦
SQL 2000
USE master GO SELECT catalog_name FROM information_schema.schemata WHERE DATABASEPROPERTYEX(catalog_name,'RECOVERY') = 'SIMPLE' ;
SQL 2005-2008
USE master GO SELECT name FROM sys.databases WHERE recovery_model_desc = 'SIMPLE'