Hi @reuvygroovy ,
Have you ever mount the origin copy such as ex1\db1 back after a failover? Please note that the database copy will not be automatically mounted after the server restarted. Which means if you didn't manually mount ex1\db1, the database db1 will be mounted permanently on another server like ex2, this procress will based on the Best Copy and Server Selection. When more servers down, more databases will be mounted on other servers, obviously it will happen that multiple database copies mounted on one server.
For your question, you could use a script named CollectOverMetrics.ps1 to collect information about the database acvitivies. This uses the Event Viewer to search for the logs related to database mount and failover ect.
Best regards,
Lou
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.