Showing posts with label localhard. Show all posts
Showing posts with label localhard. Show all posts

Sunday, February 26, 2012

Free Space Alert in Sql Server

Hi,
Is there any way I can get alert message from sql server if one of local
hard disk drive goes out of space or less than 500 mb.
Thanks,
San
I wrote a job that wakes up every hour, uses master..xp_fixeddrives to poll
the local disks, and sends an alert if any are getting low.
Run this and you should get a quick idea:
EXEC master..xp_fixeddrives
http://www.aspfaq.com/
(Reverse address to reply.)
"San" <San@.discussions.microsoft.com> wrote in message
news:D4D16EAE-50E8-409F-9172-DD715F0D0B9D@.microsoft.com...
> Hi,
> Is there any way I can get alert message from sql server if one of local
> hard disk drive goes out of space or less than 500 mb.
> Thanks,
> San