Original link: https://www.mssqltips.com/sqlservertip/2097/how-to-shrink-the-transaction-log-file-in-sql-server Desctiption: Shrink the transaction log file in SQL Server ...
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