You only need to run an Incremental backup to reset the recovery log.
Our regime is a full backup + DBSnapshot(sent offsite) on Sunday on hi-density
tapes and incrementals once a day (or twice, if recovery log fills up during the
day) on low-density ones using a 2 week rotation.
It is manually triggered as we chose to use a manual tape drive for DB backups
and the Operators keep tapes in a safe.
(an e-mail is sent to Operators whenever a ANR0314W appears and they manually
run a incremental).
We had to recover several times without a problem. Worst case would be having
to restore on a Saturday.
Cheers, Suad
--
On Thu, May 17, 2001 at 10:28:20AM +0200, Hrouda Tom� wrote:
> How often do you provide full DB backup? Maybe increase of full DB backup
> frequency can lower your recovery log needs.
>
> Tom
>
> > -----P�vodn� zpr�va-----
> > Od: Prather, Wanda [SMTP:[EMAIL PROTECTED]]
> > Odesl�no: 16. kv�tna 2001 22:38
> > Komu: [EMAIL PROTECTED]
> > P�edm�t: 5 GB limit on Recovery Log
> >
> > I've lost track - has the 5 GB limit on the size of the recovery log been
> > lifted in the V4.1 server?
> >
> > The 5 GB limit is killing me here - it would be a good reason for me to
> > upgrade....
> > ---
> > P��choz� zpr�va neobsahuje viry.
> > Zkontrolov�no antivirov�m syst�mem AVG (http://www.grisoft.cz).
> > Verze: 6.0.225 / Virov� b�ze: 107 - datum vyd�n�: 22.12.2000
> >
> ---
> Odchoz� zpr�va neobsahuje viry.
> Zkontrolov�no antivirov�m syst�mem AVG (http://www.grisoft.cz).
> Verze: 6.0.225 / Virov� b�ze: 107 - datum vyd�n�: 22.12.2000
