TravisDBA (2/10/2010)
BTW, you can write some T-SQL code with little effort that will check disk space on all fixed drives on your db server via a daily job and notify you via email if available space on any of your drives falls below a given amount. This is indispensable in preventing this from catching you unaware and sending your database into suspect mode before you can do something about it 🙂 Let me know through email talltop@bellsouth.net if you are interested and I can send it to you....
Travis, Thanks for your points.
Do you have any suggestions if we need to use this script for around 200 to 250 instances.
Then we would need to use SQLCMD or ISQL right? That is to connect to each one of them. However, ISQL would no longer be supported in future.
Otherwise, it would get too manual to set 250 jobs for 250 servers to monitor disk space.
M&M