Cannot shrink log file XX (XXXXX_LOG) because the logical log file located at the end of the file is in use

Always On and Log File

You will get this error trying to shrink the log files if the database belongs to Always On.


Preform a full database and log backup. The log file will eventually shrink after a while in the primary server. The replica server log will auto shrink. You don’t need to do anything else.

Last modified: August 13, 2020



Write a Reply or Comment