Re: change of recovery model

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 13:11:02 -0700

Thanks, Hugo. I'm new with SQL, so if I can't do a point-in-time restore of the database, how can I restore it in case of corruption or failure?
     
     ----- Hugo Kornelis wrote: -----
     
     On Tue, 25 May 2004 12:11:12 -0700, mike wrote:
     
>can the recovery model of the database be changed from Full to Simple mode? what are the implications?
     
     Hi Mike,
     
     Yes it can. Your transaction log won't keep on growing between backups,
     but you'll lose the possibility to do a point-in-time restore.
     
     Best, Hugo
     --
     
     (Remove _NO_ and _SPAM_ to get my e-mail address)
     

Relevant Pages

  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... Hugo Kornelis wrote: ... >>And then for a 10 million record database. ... >>this query would run, please. ... I don't have the money to spare on the kind of hardware that would be ...
    (comp.object)
  • Re: Referencing a column from another tables data
    ... "Hugo Kornelis" wrote: ... >>the database design at all. ... > But all the three above improvements are all about readability, ...
    (microsoft.public.sqlserver.mseq)
  • Re: Referencing a column from another tables data
    ... The problem is that the database was developed by an outside vendor and is ... the database design at all. ... "Hugo Kornelis" wrote: ... >>GroupID Page PageOffset Description ...
    (microsoft.public.sqlserver.mseq)
  • Re: DB User authentication.
    ... In article, Allan ... Hugo wrote: ... > I'm working off the user authentication and database thing off ...
    (alt.php)
  • Re: change of recovery model
    ... Your transaction log won't keep on growing between backups, ... but you'll lose the possibility to do a point-in-time restore. ... Best, Hugo ...
    (microsoft.public.sqlserver.programming)