DB Recovery Model Type through SQL

Hi,
How to write SQL to find the Recovery Model type.
Please suggest me something.
Thanks, StevenI always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=3DN'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34=A0am, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven|||Which version of SQL Server are you using? For now I'll assume SQL Server
2005, but if that's not it, you'll need to include that as a part of your
question.
SELECT name, recovery_model, recovery_model_desc
FROM sys.databases
-- WHERE name = 'my_database';
"Steven" <Steven@.nospaml.com> wrote in message
news:eEJmOepiIHA.4536@.TK2MSFTNGP06.phx.gbl...
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven
>|||WOW, that was quick.
This is exactly what I wanted.
Thanks a lot.
Steven.
"Sean" <ColdFusion244@.gmail.com> wrote in message
news:fe305fd3-7dfd-46a3-ae27-0d01a20de40b@.n58g2000hsf.googlegroups.com...
I always used (on 2K5)
select name, recovery_model, recovery_model_desc from sys.databases
where name=N'DBNAME'
or you can drop the where clause to get them all.
-Sean
On Mar 20, 10:34 am, "Steven" <Ste...@.nospaml.com> wrote:
> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
> Thanks, Steven