Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2007-01-02 : 06:01:13
|
| Hi,is there a simple query I can use to find the recovery model of all databases on my server? I have looked through the master database but I can't seem to find it...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-02 : 06:17:30
|
| you can use the the DATABASEPROPERTY (depracated) or DATABASEPROPERTYEX functions for this.sp_helpdb might also report the recovery model in the status column.-ec |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-01-02 : 08:03:40
|
| Excellent...thanx :)--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Query to find recovery model