Click here to Skip to main content
Click here to Skip to main content

Finding available free space in the disks of SQL Server

, 19 Mar 2012
Rate this:
Please Sign up or sign in to vote.
Simple query to find the available hard disk space in the server

Introduction

As part of regular maintanence we needed to send a weekly report that included available harddisk space in our PROD SQL Server. This required a remote desktop login to the restrictive PROD environment and checking the space. We were unable to automate the status checks due to this particular item, after months of doing this as a manual activity found out that a simple procedure call will return the hard disk space from the Server machine.

Using the code

Just run the below procedure, no input parameters required!!

xp_fixeddrives

Output would be like this

drive MB free
----- -----------
C     31450
D     450047

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Saral S Stalin
Technical Lead
India India
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web01 | 2.8.140827.1 | Last Updated 19 Mar 2012
Article Copyright 2012 by Saral S Stalin
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid