List recovery model of databases.

Home

Author

Message

Posted Thursday, September 27, 2007 2:41 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, November 16, 2012 2:10 PM
Points: 21, Visits: 222

Comments posted to this topic are about the item List recovery model of databases.

Post #403754

Posted Thursday, January 17, 2008 11:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, August 12, 2008 8:43 AM
Points: 1, Visits: 25

Or:

select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')

Post #444487

Posted Thursday, January 17, 2008 11:24 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 21,591, Visits: 27,398

Much cleaner and avoids loops and unnecessary temporary tables.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #444496

Posted Tuesday, April 29, 2008 10:46 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:10 AM
Points: 322, Visits: 368

Here is another one..

select name,recovery_model_desc as Recovery_mode from sys.databases order by name

Post #492333

Permissions