Post reply

Log growth on Always on availability databases on Primary server

  • November 29, 2014 at 9:47 am

    #301459

    All,

    Secondary server is offline due to a hardware issue and the log files are growing on Primary sever for availabilty databases. The log drive is running out of space. How can I stop the log growth for the primary databases? I 'm not sure when the secondary server will be available. Please help on the steps I should take.

    Many thanks in advance!

  • November 30, 2014 at 4:08 am

    #1761540

    How many secondary servers do you have for this AO group?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 30, 2014 at 6:56 am

    #1761544

    One secondary, which is setup for DR. Thanks.

  • November 30, 2014 at 7:14 am

    #1761545

    Replace the secondary or break the AG and re-setup once the secondary is available again. Don't think AGs added any other options.

    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

  • November 30, 2014 at 8:46 am

    #1761557

    Removed the dbs from AG. Will add the dbs to the AG once the DR is available.

Viewing 5 posts - 1 through 5 (of 5 total)

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