Hi All, we are running MSSQL Server 2005 on Windows 2003 RC2.
Over the weekend our transaction log, which is set for auto-grow @ 10% needed to grow it's size.
Long story short, other non-sql issues used up most of the free space on the server and the drive ran out of space. I didn't know until I logged in over the weekend to do some work.
I receive automated messages for the trans log backups that run every hour but I never received one for this error. The SQL logs do show a few hours of trans log backups failing due to disk space but the job never sent me an email.
How do I set up an email alert when
1) an auto-grow occurs
2) SQL jobs fail with disk space errors.
thanks!
Over the weekend our transaction log, which is set for auto-grow @ 10% needed to grow it's size.
Long story short, other non-sql issues used up most of the free space on the server and the drive ran out of space. I didn't know until I logged in over the weekend to do some work.
I receive automated messages for the trans log backups that run every hour but I never received one for this error. The SQL logs do show a few hours of trans log backups failing due to disk space but the job never sent me an email.
How do I set up an email alert when
1) an auto-grow occurs
2) SQL jobs fail with disk space errors.
thanks!
