fail over database in high availability - Always On

  • WhiteLotus

    SSChampion

    Points: 11878

    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

     

     

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32377

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

  • elenad80

    Grasshopper

    Points: 24

    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 3 (of 3 total)

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