Problem

--To determine how much space is used by each EMF or SM SQL filegroup in percents, run the following SQL query (e.g. using SQL Query Analyzer):

Resolution

Use EMFMail
go
SELECT ISNULL(groupname, 'EMFTransactionLog'),
    convert(decimal(12,2), round(size /128.000,2)) AS [Space Reserved], convert(decimal(12,2), round(Used /128.000,2)) AS [Space Used] ,
convert(decimal(12,2), round (CAST( Used AS FLOAT) / CAST( Size AS FLOAT) * 100.000,2)) AS [Used Percents]
    FROM
    (
    SELECT   g.groupname, SUM(size) AS Size, SUM(maxsize) As MaxSize,
    SUM(FILEPROPERTY (name, 'SpaceUsed')) AS Used
    FROM sysfilegroups as g right outer join sysfiles as f on g.groupid = f.groupid
    WHERE maxsize != -1 AND ( g.groupname like 'EMF%' or g.groupname like 'MMS%' or g.groupname IS NULL or g.groupname like 'Messenger%' )
    GROUP BY g.groupname
    ) AS FileGroupUsage

*The returned results are in megabytes (MB).

*Furthermore, to get what is the current database size, you could run the following SQL stored procedure:

EXEC sp_helpdb @dbname='EMFMail';
GO

*Database name might also be MMSMail (in rare cases).