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
