Post reply

SQL server Always-On failover

  • October 30, 2017 at 10:42 am

    #409734

    Hello,

    In one of our Production server Always-On AG group failed over automatically to secondary server. I am unable to fail back manually to  its original primary server.

    Can some one help me with below,
    1. In what circumstances fail over will happen?
    2. why i am unable to fail back manually  to its original primary server? when i try to do this request is timing out

    Thanks in Advance
    Sunny

  • October 31, 2017 at 4:30 am

    #1965923

    Hi G Sunny,

    What does the error logs show at the time when it failed over.
    Is there any error thrown when you attempt to failback to primary? You may have to check the error logs.

  • October 31, 2017 at 10:59 am

    #1966023

    Ricky Valencia - Tuesday, October 31, 2017 4:30 AM

    Hi G Sunny,

    What does the error logs show at the time when it failed over.
    Is there any error thrown when you attempt to failback to primary? You may have to check the error logs.

    Hello Ricky,
    Thanks for your reply, 
    I do not see any errors logged in SQL error log when try to fail over,
    I get the attached error in fail over wizard after it complete.

    Thanks
    Sunny

  • October 31, 2017 at 12:02 pm

    #1966036

    HI G Sunny,

    Based on the screenshot that you sent me, you have to check from the Windows Server Failover Cluster (WSFC) perspective.  You have to verify whether or not the WSFC node is online. You can also check WSFC error logs. 
    Furthermore, you have to check that the availability group resource exists in WSFC cluster.

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

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