recovery mode

Hello Group,
if I change a database recovery mode from SIMPLE to FULL, when does the
change take effect? do I need to start the SQL Server?
RichRich,
At the time the change is made.
Might want to read:
Switching Recovery Models
http://msdn.microsoft.com/library/d... />
t_8ik3.asp
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:42933A80-A832-4AE9-895E-F85D14C3740F@.microsoft.com...
> Hello Group,
> if I change a database recovery mode from SIMPLE to FULL, when does the
> change take effect? do I need to start the SQL Server?
> Rich|||Hello Jerry,
why the backup after the change, is that to put a "stack in the ground" so
to speak.
Rich
"Jerry Spivey" wrote:

> Rich,
> At the time the change is made.
> Might want to read:
> Switching Recovery Models
> http://msdn.microsoft.com/library/d...>
rst_8ik3.asp
> HTH
> Jerry
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:42933A80-A832-4AE9-895E-F85D14C3740F@.microsoft.com...
>
>|||Rich,
Simple --> Full
Stake in the ground - pretty much - allows for starting point for t-log
backups to now occur.
HTH
JErry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:2BBEB401-9A87-4B57-A746-5B888FBD6658@.microsoft.com...[vbcol=seagreen]
> Hello Jerry,
> why the backup after the change, is that to put a "stack in the ground" so
> to speak.
> Rich
> "Jerry Spivey" wrote:
>