Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL (2005) server for which I need to monitor the amount of free disk space. It is not currently running a web server so a normal ASP/.Net monitor page won't work in this case. Is there any way that I can find the amount of free disk space on the server using only a SQL query?

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

Have you tried EXEC xp_fixeddrives ?

A decent list of stored procedures which aren't well documented here

share|improve this answer
add comment

Pretty good tip here (if you allow extended stored procedures)

Determine Free Disk Space in SQL Server 2000/2005

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.