Re: Re: dbi cookbook for database administration

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!

Comment on Re: Re: dbi cookbook for database administration

Replies are listed 'Best First'.
Re: Re: Re: dbi cookbook for database administration by mpeppler (Vicar) on Nov 08, 2002 at 16:05 UTC
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]
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.	[reply]