Post reply

sql 2016 alwayson question about failover

  • March 15, 2021 at 2:06 pm

    #3858015

    Hi guys, i have this question. we have 2 sql 2016 standard with some databases replicated with basic alwayson. So last night the primary server crashed (BSOD and reboot) and the secondary sql has started the failover. This morning i have done a manual failover to move again the DB on primary server. i have a doubt, the manual failover need to be done from the sql with primary replica? or from the sql with secondary replica? or doesn't matter? thanks Andrea

  • March 16, 2021 at 2:10 pm

    #3858528

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 17, 2021 at 7:18 am

    #3858825

    Hi,

    I think it should start on the primary, you can use this script:

    -- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.

    :Connect PRIMARY_SQL_Server

    :Connect SECONDARY_SQL_Server

    ALTER AVAILABILITY GROUP [YOU_AOAG_GROUP_NAME] FAILOVER;

    Good luck,

    kind regards,

    Andreas

     

     

  • March 22, 2021 at 11:24 am

    #3860751

    Hm,

    it would be nice, if the creator of a question will give some feedback.

    Nobody knows if the solution fixed your problem.

     

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

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