SQL DBA-ASR
Monday, August 22, 2011
Recovery model and status of all Databases
SELECT name
,
DATABASEPROPERTYEX
(
name
,
'Recovery'
)
as
[Recovery Model],
DATABASEPROPERTYEX
(
name
,
'Status'
)
as
Status
FROM
master.dbo.
sysdatabases
ORDER BY
1
Newer Post
Home