Post reply

AlwaysON AG Group Transaction Logs Shrink

  • September 6, 2016 at 1:42 pm

    #329767

    Hello Everyone,

    I have a Production Database that is in the AlwaysON Group. The transaction log has grown out of control and filling up the drive.

    Here is my setup:

    Full Backup Every night (Secondary replica)

    Log backups every hour (Secondary replica)

    Backup Preferences (Prefer Secondary)

    SQL 2014

    I have been doing the log backups for months and the log was manageable, there was a huge increase in size and now I need to shrink the logs and reduce the size.

    I know it is not best practice to shrink but right now it is eating up space. I need to know a safe way to reduce the size and shrink the logs. I do not wish to remove it from the AG group if possible.

    Please help.

  • September 6, 2016 at 2:39 pm

    #1899465

    Same way you shrink any other database. DBCC ShrinkFile ('File name', Target Size)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 6, 2016 at 3:06 pm

    #1899475

    It is safe to do, no concerns on that front.


    Shamless self promotion - read my blog http://sirsql.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply