List recovery model of databases.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Chang-468251 SSC Enthusiast Points: 103 More actions · Answer 1

Or:

select [name], DATABASEPROPERTYEX([name],'recovery')

from sysdatabases

where name not in ('master','model','tempdb','msdb')

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Much cleaner and avoids loops and unnecessary temporary tables.

RPSQL Hall of Fame Points: 3229 More actions · Answer 3

Here is another one..

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