fail over database in high availability - Always On

  • WhiteLotus


    Points: 11932

    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


    Points: 32407

    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

    Valued Member

    Points: 62

    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