in reply to dbi cookbook for database administration

I posted a space checking script here - see this node.

I would check out Rob Vershoor's web site. He has a lot of information that you could probably integrate to your scripts.

Apart from that I think your list looks pretty good - I guess that monitoring databases and log also means running the backups, right?

Michael

  • Comment on Re: dbi cookbook for database administration

Replies are listed 'Best First'.
Re: Re: dbi cookbook for database administration
by busunsl (Vicar) on Nov 08, 2002 at 07:11 UTC
    I posted a space checking script here

    Great, I'll have a look. I suppose it handles mixing of data and log right.

    I know Rob and his site, it is a great source of information.

    I guess that monitoring databases and log also means running the backups, right?

    I will put backups in the disaster recovery section.
    Automatic backups of the transaction log should go into the thresholdaction procedure. I'll think about that.

    Many thanks!

[reply]
      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

[reply]
        Yes, you're right. I was not clear enough.

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

[reply]

In Section Meditations