Sunday, March 25, 2012

Alerts for failed backups

I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
Craig
If the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:

> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig

No comments:

Post a Comment