Identify a Mirror member status
I want to write some code differently to run on Primary, Backup and DR depending upon their status.
If its Primary then do something, if Backup then something else and if DR then do something different from both Primary and Backup.
This can identified whether a system is Primary or Not Primary by calling below method
1 means Primary and 0 means Not Primary. But a Not Primary member may be a backup or a Async DR or a Async Reporting.
How to identify if a system is a DR or Backup or Reporting?