Checking Database Recovery Mode

Hi,
How can I find out what the current recovery mode of a database is?
I know that I can set it with ALTER DATABASE command but I don't know how to
check to see what the current mode is. Could you please someone help me?
I didn't find anything in sysdatabases table.
Thank you,
RosieTry:
SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> Hi,
> How can I find out what the current recovery mode of a database is?
> I know that I can set it with ALTER DATABASE command but I don't know how
> to
> check to see what the current mode is. Could you please someone help me?
> I didn't find anything in sysdatabases table.
> Thank you,
> Rosie
>|||Great! Thank you for your help.
Rosie
"Dan Guzman" wrote:
> Try:
> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
> > Hi,
> >
> > How can I find out what the current recovery mode of a database is?
> >
> > I know that I can set it with ALTER DATABASE command but I don't know how
> > to
> > check to see what the current mode is. Could you please someone help me?
> >
> > I didn't find anything in sysdatabases table.
> >
> > Thank you,
> > Rosie
> >
>
>|||I'm glad I was able to help.
--
Dan Guzman
SQL Server MVP
"Rosie" <Rosie@.discussions.microsoft.com> wrote in message
news:685AF33B-8EBC-4BE5-9D15-556A1712A1CD@.microsoft.com...
> Great! Thank you for your help.
> Rosie
> "Dan Guzman" wrote:
>> Try:
>> SELECT DATABASEPROPERTYEX('MyDatabase', 'Recovery')
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Rosie" <Rosie@.discussions.microsoft.com> wrote in message
>> news:3EB4D6F6-7813-40C0-990B-2FF8E3EEDEE1@.microsoft.com...
>> > Hi,
>> >
>> > How can I find out what the current recovery mode of a database is?
>> >
>> > I know that I can set it with ALTER DATABASE command but I don't know
>> > how
>> > to
>> > check to see what the current mode is. Could you please someone help
>> > me?
>> >
>> > I didn't find anything in sysdatabases table.
>> >
>> > Thank you,
>> > Rosie
>> >
>>