MSSQL – Find white/free space in database file and log files.
Replace master, with the name of you database
1 2 3 4 5 6 7 8 |
use master; SELECT [File Name] = name, [File Location] = physical_name, [Total Size (MB)] = size/128.0, [Available Free Space (MB)] = size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0, [Type] = type_desc FROM sys.database_files; |
Sidste kommentar