Mirror Member List
What's the best way to get list of members attached to a Mirror?
In my scenario, in a Mirror set there are 5 members. 2 Failover, 2 DR Async and 1 R/W reporting.
On Primary, in the code I want to identify Backup member and then do my stuff.
And on Backup, in the code I want to identify DR Async and then do my stuff.
Basically the idea is to push file through code from Primary > Backup and then later files will be pushed from Backup > DR Async.