Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

How to view SQL Server mount point space without access to server

11 March,2024 by Tom Collins

Question : I'd like to view the mounpoint size & freespace for a SQL Server installation , but do not have access to the server directly i.e through RDP.Also there are no user databases currently on the dedicated user database mountpoints so am not able to work out the physical name . 

The only information I have is the  server & share details  .     For example   "\\myserver\h-share\mydata"  .   

 

Answer:  If you're using Powershell and have sufficient privileges , one option is to investigate the Get-WmiObject Win32_Volume  class on Get free disk space for mount points using Powershell

If you're getting Access Denied issues , than another option is the dir command , typically used to display the the durectory files and subdirectories . 

To use it for the moutpoint details - you'd execute the command similar to :  dir/s \\myserver\h-share\mydata   . As well as supplying the folder and directory list - there'll be a summary of files size aggregates at the bottom of the result set . Adding these totals will give you the full size 

Example : 

Total Files Listed:
0 File(s) 99,000 bytes
9 Dir(s) 644,100,980,736 bytes free


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to view SQL Server mount point space without access to server


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer