changing recovery model

Do I need to re-cycle the server when changing the recovery model from full
to bulk logged? I can't find anything in the newsgroup or in the books onli
ne.It is NOT necessary to cycle the server when changing recovery models.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"steve harris" <anonymous@.discussions.microsoft.com> wrote in message
news:968EB502-2357-4B76-A8AF-DE5839BFC9CE@.microsoft.com...
> Do I need to re-cycle the server when changing the recovery model from
full to bulk logged? I can't find anything in the newsgroup or in the books
online.|||In addition to Geoff's remark:
You might want to do a transaction log backup before you change the recovery
model from full to bulk_logged.. If the transaction log contains any bulk
logged transactions, you won't be able to do a point-in-time restore.
Jacco Schalkwijk
SQL Server MVP
"steve harris" <anonymous@.discussions.microsoft.com> wrote in message
news:968EB502-2357-4B76-A8AF-DE5839BFC9CE@.microsoft.com...
> Do I need to re-cycle the server when changing the recovery model from
full to bulk logged? I can't find anything in the newsgroup or in the books
online.