Listing mount point information from within SQL Server - by Troels S Eriksen

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 301832 Comments
Status Closed Workarounds
Type Suggestion Repros 10
Opened 10/1/2007 5:23:50 AM
Access Restriction Public


Neither SQL Server 2000, SQL Server 2005 or SQL Server 2008 is able to list existing mount points or mount point info (like total disk space and free space) through xp_fixeddrives or xp_available media or other extended stored procedures.

Neither does the Management Studio mark mount points as such, f.x. during the "New Database" dialog when you want to control where database files are stored this information would be nice - plus of course, a way to easily check that the wanted / needed space actually are available... 

Currently the only way of identiftying that a given folder is a mount point through Management Studio is when the "System Volume Information" folder is shown in a subfolder.

Double mounting a drive through both a drive letter and a mount point is not an option on a cluster with many instances or luns attached + plus it may confuse backup systems, antivira software etc when the same drive is accessible through different paths.

Further there is a small problem with xp_fixeddrives and xp_availablemedia since they list cluster disk resources outside the scope of the current sql server instance.
Sign in to post a comment.
Posted by Joie Andrew on 10/4/2012 at 8:03 AM
On servers that are Windows Server 2008+ what about making an extended stored procedure that queries the Win32_Volume WMI class? Our team now is trying to see if we can do that via a PowerShel query that outputs the resultset into variables that then get input into a table in SQL.

It would be nice if this could be done natively though. Extremely useful information considering how Enterprise systems are engineered nowadays.
Posted by Microsoft on 4/1/2011 at 1:19 AM

Greetings from the SQL Server Manageability Team.

We triaged this enhancement along with several others. Unfortunately, considering the work involved in implementing this, and our current deliverables/committments, we regret to let you know that, we will not be able to implement this in the near future. We will keep track of this internally, and will get to it, when the opportunity arises.

Thanks for writing into Microsoft.


SQL Server Manageability
Posted by Nilton Pinheiro - MVP on 10/29/2010 at 4:53 AM
Hi Guys...any workaround for this? So that more and more people are using mount point on SQL Server, sounds good if MS pay attention to this and at least provide a workaround.

Nilton Pinheiro
Posted by Kevin [MSFT] on 11/20/2007 at 10:53 AM
Having the ability to manage the storage that the databases are configured on would be a valuable enhancement to the SQL product. Unfortunately, it won't fit in the current release. We are keeping your suggestion active for consideration in future releases.