Home Forums Article Discussions Article Discussions by Author Discuss content posted by Aaron Nelson Finding Free Space per Data File with PowerShell RE: Finding Free Space per Data File with PowerShell

  • May 11, 2011 at 9:08 am

    #1323111

    Ofer Gal (5/11/2011)

    On the SQL server I only have PS1

    and the hard way gives me error:

    Unexpected token 'in' in expression or statement.

    At D:\Temp\freeInDB.ps1:11 char:40

    + $cmdStatement+=foreach ($DFileGroups in <<<< $db.FileGroups)

    I just need to know how much unused space (GB) I have in 309GB database.

    even a SQL script will do.

    DBCC SQLPERF(logspace)

    There is an exception to every rule, except this one...