SQL Server: Free space occupied by log files
It might happen to remain without free space on disk allocated to log files. One option is to try force shrink files for database. It might be benefic to try first on Synchronized
ones.
USE [shrink_test]
GO
DBCC SHRINKFILE (/*file_name*/N'shrink_test', /*target_size*/0, /*option*/TRUNCATEONLY)
GO
or by using SSMS tool, see bellow
Select File Type = Log
According to T-SQL Reference for TRUNCATEONLY parameter:
Releases all free space at the file’s end to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the last allocated extent.
target_size is ignored if specified with TRUNCATEONLY.
The TRUNCATEONLY option does not move information in the log, but does remove inactive VLFs from the end of the log file. This option isn’t supported for FILESTREAM filegroup containers.