Error:

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.

Fix:

Preform a database 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: July 30, 2020

Author

Comments

Write a Reply or Comment