DB Recovery Model Type through SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 20 Mar 2008 15:34 GMT

Hi,
How to write SQL to find the Recovery Model type.
Please suggest me something.

Thanks, Steven

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 20 Mar 2008 15:55 GMT

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';

> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
>
> Thanks, Steven

Reply to this Message

Sean - 20 Mar 2008 15:55 GMT

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

> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
>
> Thanks, Steven

Reply to this Message

Steven - 20 Mar 2008 16:08 GMT

WOW, that was quick.
This is exactly what I wanted.

Thanks a lot.
Steven.

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

> Hi,
> How to write SQL to find the Recovery Model type.
> Please suggest me something.
>
> Thanks, Steven

Reply to this Message