Post reply

fail over database in high availability - Always On

  • September 16, 2019 at 5:34 am

    #3680189

    Hi All,

    Currently we have configured Always on - High Availability in our SQL servers. We need to fail over per database not per Availability group because in 1 availability group we have multiple databases.

    How do I fail over 1 database in Always on environment ?

    Any feedback is much appreciated

     

     

  • September 16, 2019 at 12:10 pm

    #3680275

    If you need to fail over a single database at a time then you must have an Availability Group containing only that one database.

  • September 24, 2019 at 1:29 pm

    #3682937

    Yes, it’s not possible to choose which databases to fail over on inside the same AG : when you do fail over you do it per AG , and so you fail over on ALL the db belonging to it.

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

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