| 标题 | sqlserver数据库获取数据库信息 |
| 内容 | 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 |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。