T-SQL script to find out SQL SERVER FileGroup space details:
SELECT fg.groupname AS 'File Group', Name, CONVERT (Decimal(15,2),ROUND(f.Size/128.000,2)) [Currently Allocated Space (MB)], CONVERT (Decimal(15,2), ROUND(FILEPROPERTY(f.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)], CONVERT (Decimal(15,2), ROUND((f.Size-FILEPROPERTY(f.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)] FROM dbo.sysfiles f (NOLOCK) JOIN sysfilegroups fg (NOLOCK) ON f.groupid = fg.groupid ORDER BY fg.groupname
No comments:
Post a Comment