alter database <name > set recovery Full/simple/bulk-logged

On Wed, 26 Feb 2003 Sarita Janjani wrote :
>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] 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