How to get available space for the Drive where a database Data File is located

Question

Post reply

How to get available space for the Drive where a database Data File is located

compass_ms

SSC Veteran

Points: 227
More actions
June 9, 2008 at 8:16 am

#122953

I got requirements for a web application (back-end is SqlServer) that needs below informations got presented on a web page:
1. Drive Space Available (Drive where Data File is located)
2. Percent(%) of Drive Space Free
How I can implement this by using SMO (Sqlserver Management Object)
Thanks a lot,
Mark

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 1

Using XP_FIXEDDRIVES you can get the free disk space in all drives:D

compass_ms SSC Veteran Points: 227 More actions · Answer 2

Is there anyway to get those information by SMO(Sqlserver Management Object)

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 3

Here is a script that will return all of the information. Do you have to use SMO?

http://www.mssqltips.com/tip.asp?tip=1510

Gordon-265412 SSCrazy Points: 2898 More actions · Answer 4

SMO doesn't support drive enumeration...it's only relevant to SQL Server objects.

You'll need to use WMI or a FileSystemObject. I'll have a solution for this posted on my blog[/url] shortly using Powershell & WMI. Stay tuned if you're interested....

Your friendly High-Tech Janitor... 🙂

compass_ms SSC Veteran Points: 227 More actions · Answer 5

Very exicted to hear you will have a solution posted very soon. When is it suppose to be there? I would appreciate your help very much.

Thanks a lot,

Mark

Gordon-265412 SSCrazy Points: 2898 More actions · Answer 6

A day or so. I'm going to finish a current topic and then post the script in another entry.

Your friendly High-Tech Janitor... 🙂