Re: changing recovery model

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 11:25:00 -0500

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.

Relevant Pages

  • Re: Write query to find Recovery Model...
    ... > "Brett Davis" wrote in message ... >> Is there a query that i can write to find out the recovery models for all ... >> my system and user databases on my server? ... >> I am using SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
  • Re: dts & transaction logging
    ... "Allan Mitchell" wrote: ... Because the DB is SQL Server 7 did you mean to specify these options select into/bulkcopy and trunc. ... Recovery models came in for SQL Server 2000 IIRC. ... Was this hint already available for the SQL7 bulk insert DTS task? ...
    (microsoft.public.sqlserver.dts)
  • Re: How to limit the number of sql statements ?
    ... >SQL Server 2000 implemented recovery models which were ... equivalent of setting database options ... To see this compatibility visit ...
    (microsoft.public.sqlserver.mseq)
  • Re: How to limit the number of sql statements ?
    ... SQL Server 2000 implemented recovery models which were equivalent of setting database options ... To see this compatibility visit ...
    (microsoft.public.sqlserver.mseq)
  • Re: Allowing only certain clients access to SQL Server 2K
    ... I support the Professional Association for SQL Server and its user community ... "Raj Bhaskar" wrote in message ... it said "Must declare variable @spid". ...
    (microsoft.public.sqlserver.security)