Get Secondary replica name in a variable

• SQLAddict01

  SSC Eights!

  Points: 885

  More actions

  February 13, 2020 at 4:55 pm

  #3725678

  I need to pass secondary replica name in a variable to a command

  for example

  I get the primary replica name using

  Get-DbaAvailabilityGroup -SqlInstance ListenerName| Select-Object * -ExpandProperty PrimaryReplicaServerName

  How do I get the secondary replica name?

   

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  February 13, 2020 at 5:16 pm

  #3725694

  dbatools also has the cmdlet Get-DbaAgReplica that you may want to try.

  Sue