Pranav,

Select a database name under "Databases" in EM, right click and choose
"properties" then click on "Options" tab. Recovery option information is in
the middle section next to "Model".

Sang
x6746


-----Original Message-----
From: Pranabesh Sarkar [mailto:[Email Address Removed] Tuesday, February 25, 2003 4:42 PM
To: LazyDBA.com Discussion
Subject: Database Recovery Model


Hi All,

How can I find out the recovery model of a database. I mean if the database
Northwind (or some other database) is running as "Simple Recovery Model" or
"Full Recovery" or "Bulk-Logged recovery".. Where can one check that?

Regards,
Pranav

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page