Wednesday 21 August 2013

Find database file size 

SELECT DB_NAME(dbid) AS DatabaseName,
Name AS LogicalFileName,
CASE WHEN GroupID=1 THEN 'Data' ELSE 'Log' END AS FileType,
FileName AS FilePath, size AS TotalPage,
(Size*8192E)/1048576 AS FileSizeInMB
FROM master..SysAltFiles

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)