SELECT name,
DATABASEPROPERTYEX(name, 'Recovery') as [Recovery Model],
DATABASEPROPERTYEX(name, 'Status') as Status
FROM master.dbo.sysdatabases
ORDER BY 1
Use this query to get the recovery model and status of all the databases present in the server.
OR
EXEC sp_msforeachdb 'Select databasepropertyex(''?'', ''recovery'')as ''Recovery Model of ? Database'''
To find only the recovery model of all the databases.
9 comments:
I know it has been a year since this was posted but it is never to late for a comment. Thank you for this it is exactly what I needed.
Works great
Three years after the posting, this tip still comes in handy, thanks!
Yes.
Nice.
Hello there, just became alert to your blog through Google, and found that it’s truly informative. I am going to watch out for brussels. I’ll appreciate if you continue this in future. Lots of people will be benefited from your writing. Cheers! https://techcaption.com/boot-into-lg-g4-recovery-mode/
Hello, thanks for this share, I will try this recovery next time ...
regards
Tangki Panel
Excellent read, I simply passed this onto a colleague who was doing slightly analysis on that. And hubby actually bought me lunch as a result of I came upon it for him smile thus well then , ill rephrase that: thank you for lunch! https://royalcbd.com/product/cbd-capsules-25mg/
Đặt vé tại phòng vé Aivivu, tham khảo
Vé máy bay đi Mỹ
các chuyến bay từ mỹ về việt nam hiện này
mua ve may bay gia re tu duc ve viet nam
dịch vụ vé máy bay tại nga
mua vé máy bay từ anh về việt nam
các chuyến bay từ châu âu về việt nam
giá khách sạn cách ly
Chi phi cho chuyen gia nuoc ngoai
Post a Comment