locked
Not able to shrink logs in Always On RRS feed

  • Question

  • Hi Folks,

    I am facing an issue on one of our Always On SQL Server

    Log backups are configured on secondary node

    I am trying to shrink the log files on primary server but it is not shrinking.

    when i checked log_reuse_wait_desc then it is showing AVAILABILTY_REPLICA, estimated recovery time it is showing approx 27000 secondsand keep on increasing.

    Always On is configured with Asynchronous Mode

    Any thought how to resolve this issue

    Friday, January 1, 2021 7:29 AM