Shulou(Shulou.com)06/01 Report--

/ * * 9.sqlserver query database size method * * /

-- headquarters requires that the growth size of the ERP database be obtained once a month.

Source: http://www.jb51.net/article/30993.htm

SELECT DB_NAME (database_id) AS [Database Name], [Name] AS [LogicalName], [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 ('Conductor')

GO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.