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.
Top Menu
Ads
10 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
The secrets as well acted to be the fantastic way to recognize that many people have the identical dreams the same as my personal own to figure out way more with reference to this problem. I believe there are many more fun instances in the future for individuals that examine your blog post.
Jual Septic Tank
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/
Great Article Artificial Intelligence Projects
Project Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Post a Comment