Post reply

SQL alwayson Checkup after PROD up

  • February 23, 2017 at 4:45 am

    #335249

    PROD and COB databases are configured in always on high availability mode..manual failover(Asynchronous).App team will shutdown prod db server then do some some changes on COB server not on COB database side.NOte:App wont touch COB Database.
    Once app test done on COB server,App team will bring up PROD db server.My doubt is any issue in existing always on after PROD up 2 hours delay.
    Could any one suggest.

    Regards,
    Kumar

  • March 7, 2017 at 11:38 pm

    #1932216

    Hi Kumar,

    There wont be any issue. Once the Server is UP, just monitor the synchronization state.

    There was one time that our secondary replica in AAG was down for a week due to server issue. After it was brought up, the always On availabilty group just went back to normal.

    Thank you.

    Best Regards,
    Ricky

  • March 8, 2017 at 3:39 am

    #1932242

    yeah sure .Thanks a lot Ricky.

    Regards,
    Kumar

  • March 16, 2017 at 11:40 am

    #1933582

    https://msdn.microsoft.com/en-us/library/ff878259.aspx

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

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