Paweł Domański
19 lines
622 B
SQL
19 lines
622 B
SQL
/*
|
|
HostName name FileType PhysicalFile OnlineStatus type_desc FileSize SizeInBytes
|
|
DESKTOP-NG9J589 DBATools DBATools C:\MSSQL\MSSQL14.MSSQLSERVER\MSSQL\DATA\DBATools.mdf ONLINE ROWS 8 MB 8192 Bytes
|
|
**/
|
|
|
|
SELECT
|
|
serverproperty('ComputerNamePhysicalNetBIOS') as HostName,
|
|
D.name,
|
|
F.Name AS FileType,
|
|
F.physical_name AS PhysicalFile,
|
|
F.state_desc AS OnlineStatus,
|
|
type_desc,
|
|
CAST((F.size*8)/1024 AS VARCHAR(26)) + ' MB' AS FileSize,
|
|
CAST(F.size*8 AS VARCHAR(32)) + ' Bytes' as SizeInBytes
|
|
FROM
|
|
sys.master_files F
|
|
INNER JOIN sys.databases D ON D.database_id = F.database_id
|
|
ORDER BY
|
|
D.name |