Home Forums SQL Server 2008 SQL Server 2008 Administration How to monitor remaining drive space without RDP access (only SSMS sysadmin rights have been granted) RE: How to monitor remaining drive space without RDP access (only SSMS sysadmin rights have been granted)

  • April 9, 2014 at 3:01 pm

    #1704700

    defyant_2004 (4/8/2014)

    Unfortunately no I do not. Our server admin does not like to give any more permission than necessary. He feels sysadmin is enough and that it should be able to be done via SSMS. The drive space is an OS object, not a SQL object. I do not see how this can be achieved.

    Be aware that xp_fixeddrives does not work for mounted volumes. For reliable disk space info, from SSMS you can enable XP_Cmdshell and use the following

    exec xp_cmdshell 'wmic volume get capacity, "free space", name'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉