While shrinkning log file of one database on SQL 2005 instance I get below message: "Cannot shrink log file 2(name) because all logical log files are in use". I am able to shrink log files of other databases successfully.
I have checked that log backup is happening successfully. I have also checked that there are no open transactions on this database. Please advise.
P.S : I know disadvantages of shrinking. I am looking for explanation to my problem and not alternate options.