paul.t.silvey (9/8/2008)
Automate this stuff.... why manually look... but do not have you database server watch itself. That is like an internal investigation. Not much checks and balances there.
I agree it's not the best idea to rely on a server checking itself. If you have multiple servers then have the servers checking each other. Have them provide daily reports, that way you have an extra chance of becoming aware of a problem if you do not receive the report(s).
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]