查询数据库名称及路径,空间文件大小

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
posted @ 2019-12-14 17:31  梦想(胡大利)  阅读(289)  评论(0编辑  收藏  举报