Post reply

Planned and scheduled failover

  • December 7, 2015 at 1:58 am

    #323157

    Hi everyone,

    I am looking for a solution to bypass our company policy to automatically reboot a server after patching. They do it with every server, regardless of what service is running on these servers.

    I really don´t want them to test my always on configuration the hard way once a month- so would it be a good thing to implement a scheduled failover?

    Is a scheduled job just executing "alter availability group xyz failover" fair enough or is there a better way?

    Thanks in advance!

    ps. it is just one database, two servers with one AG

  • December 7, 2015 at 6:43 am

    #1844353

    are the replicas configured synchronously or asynchronously?

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

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

  • December 7, 2015 at 6:57 am

    #1844359

    We are using synchronous commit

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

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