Sunday, September 13, 2015

List the Recovery Model of All DB on SQL Server

/* Code to List all Recovery Models */

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

No comments:

Post a Comment