Database Recovery Model

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
MS Sql Server LazyDBA home page