By Lukas Hillesheim, 8 August, 2023
Shrinking the log file is an occasional administrative task in SQL Server. In some cases the logfile can only be shrinked by temporarily applying the SIMPLE recovery mode. The measures to solve the problem can harm the backup chain and - depending on your point of view - can be seen as a bug or an annoying behavior. With AlwaysOn Availability Group an additional problem arises, because a database that is part of AON cannot be switched to the SIMPLE recovery mode without resetting the AON cluster configuration. The following article shows a solution.