SQL Server Forums - disk usage

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

disk usage

New Topic

Reply to Topic

Printer Friendly

Author

Topic

inbs
Aged Yak Warrior

811 Posts

Posted - 11/19/2012 : 02:43:08

how can i know by sql

what is the size of my disks in all my servers in the net.
(sql server is not installing in all the servers)

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts

Posted - 11/19/2012 : 02:48:15

hmm...do you mean you need to find out disk size of boxes where sql server is not installed by using t-sql?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

inbs
Aged Yak Warrior

811 Posts

Posted - 11/19/2012 : 04:09:46

yes, do you know if it possible?
if not, do you know free tool for that?

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts

Posted - 11/20/2012 : 02:44:23

quote:
Originally posted by inbs

yes, do you know if it possible?
if not, do you know free tool for that?

why do you need to do it from sql? why cant you use a batch script for that?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

inbs
Aged Yak Warrior

811 Posts

Posted - 11/21/2012 : 16:54:25

do you have example of batch?

srimami
Posting Yak Master

152 Posts

Posted - 11/21/2012 : 23:20:46

use xp_fixeddrives to find the free disk space; let me know if this is what you are looking for

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1775 Posts

Posted - 11/22/2012 : 14:47:30