查询数据库大小

SELECT 
	DB_NAME(database_id) AS [Database Name],
	[Name] AS [Logical Name],
	[Physical_Name] AS [Physical Name],
	((size * 8) / 1024) AS [Size(MB)],
	[differential_base_time] AS [Differential Base Time]
FROM sys.master_files
WHERE DB_NAME(database_id) IN('ShengShiDB')

 

posted @ 2012-10-28 03:12  星火卓越  阅读(162)  评论(0编辑  收藏  举报