Solved

get list of disks for MS SQL Server instance

Posted on 2013-05-29
4
384 Views
Last Modified: 2013-05-30
Hello,

Is it possible to get of disks for MS SQL Server instance?
If yes, how?

Thanks
0
Comment
Question by:bibi92
  • 3
4 Comments
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39206344
EXEC master..xp_fixeddrives

see:
http://www.stevefibich.net/wordpress/2011/05/05/top-10-obsucre-t-sql-commands/
which also suggests:
EXEC Xp_dirtree ’c:’, 1, 1

which is further explained here
http://www.sql-server-performance.com/2001/extended-stored-procedures/

does this help?
0
 

Author Comment

by:bibi92
ID: 39206740
Hello
Thanks, i Know these commands. I search to get the Disks with powershell command.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39206761
ah, I see - in the topics - probbaly should include that in the question text - anyway:
I can spell powershell, that's about the limit :)
trust someone else will fill in that bit for you. Cheers. Paul
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39206765
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Set OWA language and time zone in Exchange for individuals, all users or per database.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question