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 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.
Comments