Post reply

Alway on Availability group cluster less

  • March 5, 2024 at 9:50 pm

    #4390216

    Hi

    for dr purposes i need to setup an on prem db in replica with a db on azure on a iaas vm

     

    i'll use sql always on availaility group in clusterless ag mode , if i need to test the secondary node do i have to do a failover? what about the fallback?

     

    or can i just use a sql cliente and connect to the secon node to do some testin since it's a read replica f the primary on prem db?

     

    any indication would be appreciated.

    Thanks

     

    • This topic was modified 8 months, 3 weeks ago by  aresblade.

  • March 6, 2024 at 10:10 pm

    #4390879

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

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

  • March 8, 2024 at 3:51 pm

    #4391970

    Hi,

    With a Clusterless Availability Group (AG), there isn't a traditional Listener that can automatically handle failover and failback operations. Manual intervention is required for both failover and failback processes. However, it's important to note that you can still utilize the secondary server for read-only purposes.

    Instead of using a Listener name in the connection string, you would need to use the instance name or server name of the SQL server. This allows for read-only access to the secondary server.

    Thanks,
    Abhinav

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

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