Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

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

Determine Free Disk Space in SQL Server 2000/2005

share|improve this answer

Your Answer


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.