Hi

I tried
CHECKPOINT
DBCC SHRINKFILE(Invoice_Log)

----

Cannot shrink log file 2 (Invoice_Log) because all logical log files are in use.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
8 2 142544 3185 142544 3184

---
dbcc sqlref shows

Database Name = 'Invoice'; Log Size ( MB) = 1113.6172 ; Log Space Used (%) = 7.017683 ; Status = 0;