亚洲免费不卡_在线视频精品_国产尤物精品_久久久久网址_久久精品91_欧美va天堂在线_狠狠入ady亚洲精品_亚洲午夜精品福利_国产精品草草_午夜精品久久99蜜桃的功能介绍

MS SQL SERVER 獲取當前數據庫文件等信息，適用于多個版本：

代碼如下:

SELECT dbf.file_id AS FileID

, dbf.name AS [FileName]

, s.filename AS FileLocation

, CAST(dbf.size/128.0 AS DECIMAL(19,2)) AS FileSizeMB

, CAST(CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS SpaceUsedMB

, CAST(dbf.size/128.0 - CAST(FILEPROPERTY(dbf.name, 'SpaceUsed') AS int)/128.0 AS DECIMAL(19,2)) AS AvailableSpaceMB

, CAST((dbf.size / 128.0 - (FILEPROPERTY(dbf.name, 'SpaceUsed') / 128.0)) / (dbf.size / 128.0) * 100 AS DECIMAL(19,2)) AS [%FreeSpace]

, dbf.growth / 128 AS FileGrowthMB

, f.name AS FilegroupName

FROM sys.database_files dbf

INNER JOIN sys.sysfiles s ON dbf.name = s.name

LEFT JOIN sys.filegroups f ON dbf.data_space_id = f.data_space_id

ORDER BY dbf.name;

例如我們在某個Database上，執行結果是：

代碼如下:

XXX_standard_data

D:\Program Files\SQLServer2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\wolf_wanzheng.mdf 2000.00 1286.38 713.63 35.68 0 PRIMARY

XXX_standard_log

D:\Program Files\SQLServer2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\wolf_wanzheng_2.ldf 157.19 2.47 154.72 98.43 0 NULL

XXX_temp2_data

D:\Program Files\SQLServer2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\wolf_wanzheng_1.ndf 500.00 0.06 499.94 99.99 0 temp2

XXX_temp2_log

D:\Program Files\SQLServer2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\wolf_wanzheng_3.ldf 142.88 2.25 140.63 98.43 0 NULL

更多信息請查看IT技術專欄