Free disk space in a cluster RRS feed

  • Question

  • Hi,

    is there a way to restrict the result of xp_fixeddrives only to those drives the SQL Server cluster group has a dependency on? Or, to say more generally, how can one find out the free disk space available for remote clustered SQL Server using only TSQL?

    Thanks a lot.



    Wednesday, September 13, 2006 9:36 AM

All replies

  • try:

    select * from fn_servershareddrives()


    select * from sys.dm_io_cluser_shared_drives

    Thursday, September 14, 2006 7:31 PM