Error:

Getting unable to clear transaction log error when trying to run a transaction log backup. Also unable to expand log size limits.

Resolution:

Make sure Always On databases are working and synchronizing on all secondary database servers. You will not be able to clear the transaction log if there is a problem with Always On for secondary database servers.

Open up “Show Dashboard” for Always On High Availability. Make sure there is no error in the dashboard for Always On for all secondary servers.

Last modified: October 23, 2022

Author

Comments

Write a Reply or Comment