Changing Recovery Mode

If I change recovery mode on a database from FULL to SIMPLE, when is this
change effective?
Immediately.
Andrew J. Kelly SQL MVP
"Dave" <davefrick@.newsgroup.nospam> wrote in message
news:eTlP26olEHA.2500@.TK2MSFTNGP09.phx.gbl...
> If I change recovery mode on a database from FULL to SIMPLE, when is this
> change effective?
>
|||Hi,
Change will be effective immediately. But if you need to change the Recovery
model back to FULL then you need to do a FULL database
backup to recreate the backup chain. After that you could start your
Transaction log backup.
Thanks
Hari
MCDBA
"Dave" <davefrick@.newsgroup.nospam> wrote in message
news:eTlP26olEHA.2500@.TK2MSFTNGP09.phx.gbl...
> If I change recovery mode on a database from FULL to SIMPLE, when is this
> change effective?
>