goto EM---click on database---right click and say properties--goto options
menu--and see Model.

-----Original Message-----
From: Pranabesh Sarkar [mailto:[Email Address Removed] Wednesday, February 26, 2003 3:12 AM
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