|
1 2 3 4 5 6 7 8 9 10 |
SELECT name, DATABASEPROPERTYEX(name, 'Recovery') AS [recovery], DATABASEPROPERTYEX(name, 'IsAutoShrink') AS [auto-shrink], CASE WHEN primary_database IS NULL THEN 'no' ELSE 'yes' END AS [log-shipped], DATABASEPROPERTYEX(name, 'IsInStandBy') AS [stand-by], DATABASEPROPERTYEX(name, 'Status') AS [status] FROM master.dbo.sysdatabases sdb LEFT JOIN msdb.dbo.log_shipping_primary_databases lspd ON lspd.primary_database = sdb.name ORDER BY 1 |
Views – 2169