/*
DataBase의MDF 와LDF 파일크기가져오기
*/
DECLARE @DB_NAME VARCHAR(100)
SET @DB_NAME = 'KC'
SELECT
디비명= DB.NAME
,논리명= MF.NAME
,물리명= PHYSICAL_NAME
,[파일크기(KB)] = CAST(MF.[SIZE] * 8 AS DECIMAL(15,2))
,[파일크기(MB)] = CAST(MF.[SIZE] * 8 /1024.0 AS DECIMAL(10,2))
,[파일크기(GB)] = CAST(MF.[SIZE] * 8 /1024.0 /1024.0 AS DECIMAL(10,2))
FROM
MASTER.SYS.DATABASES AS DB
INNER JOIN
MASTER.SYS.MASTER_FILES AS MF
ON
MF.DATABASE_ID = DB.DATABASE_ID
WHERE
DB.NAME = @DB_NAME
ORDER BY DB.NAME
/*
하드디스크의사용가능한공간가져오기
*/
DECLARE @HARDDISK TABLE(DRIVE VARCHAR(100),MB_SIZE INT)
INSERT @HARDDISK EXEC MASTER.DBO.XP_FIXEDDRIVES
SELECT
[드라이브명] = DRIVE
,[사용가능한공간(MB)] = MB_SIZE
,[사용가능한공간(GB)] = CAST(MB_SIZE/1024.0 AS DECIMAL(10,2))
FROM @HARDDISK
디스크 전체 가져오기 참고 사이트 : http://ddoung2.tistory.com/122