MS SQL server log file shrink failed while AMQ DB maintenance.

Issue

• AMQ is using MS SQL Server as the message store. When attempting to shrink the database log, the following error is encountered.

Cannot shrink log file 2 (sgamqxd1_log) because the logical log file located at the end of the file is in use.
DbId   FileId      CurrentSize MinimumSize UsedPages   EstimatedPages
------ ----------- ----------- ----------- ----------- --------------
8      2           29640       1280        29640       1280

• Only after stopping AMQ services, the shrink completed successfully. It seems that there is uncommitted transactions in the DB, causing the DB logs to be locked (in used).