increments until it reaches a target free space limit. Run this script in the database with the file to be shrunk. 1. Set @DBFileName to the name of database file to shrink. 2. Set @TargetFreeMB to ...
CAST(size * 8 / 1024.0 AS DECIMAL(18,2)) AS total_size_mb, CAST(FILEPROPERTY(name, 'SpaceUsed') * 8 / 1024.0 AS DECIMAL(18,2)) AS used_mb, CAST((size - FILEPROPERTY ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results