Re: Best Backup Plan For Archive Mode

Bad idea.

Any time I see the words "worried about space used by logs", I think "you shouldn't even be in archive log mode then".

There are lots of backup threads at the moment: have a read of those. In general, being too eager to delete prior archives is a bad, bad, bad, bad idea (and makes the mean-time-to-recover much bigger than it otherwise ought to be).

Regards
HJR "news" <pfs_at_novabase.pt> wrote in message news:x8lu6.200$BS7.856183_at_newsserver.ip.pt...
> Hi,
>
> Recently, we´ve putted our DB on Archive Mode, but now we´re worried about
> execute a backup plan that mantain the consistence off the DB and reduce
 the
> space used by logs on disk.
> The solution will pass by executing a script that do the backup of the db
> and the Logs created by archive, and after that, delete those same logs.
> Can anyone help me, Doing that script?
>
> Thank you
>
> PFS
>
> Pfms_at_mail.pt
>
>
Received on Thu Mar 22 2001 - 13:56:25 CST