in reply to Re: Re: dbi cookbook for database administration
in thread dbi cookbook for database administration

Automatic backups of the transaction log should go into the thresholdaction procedure.
I guess it's a matter of taste - but I prefer to have manual tran dumps run every X minutes/hours rather than letting the thresholdaction proc handle it - this gives me a better defined recovery window when handling a site without a warm standby.

Michael

  • Comment on Re: Re: Re: dbi cookbook for database administration

Replies are listed 'Best First'.
Re: Re: Re: Re: dbi cookbook for database administration
by busunsl (Vicar) on Nov 11, 2002 at 07:50 UTC
    Yes, you're right. I was not clear enough.

    Regular backups every x minutes are a must.
    The thresholdaction procedure is for emergency.