We are using mirroring between two SQL 2005 Standard edition installations. ServerA is the host of the principal database. ServerB is the host of the mirrored version.
Is there a way to determine the history of flips? Meaning how do we determine when the databases have flipped. We don't see a specific eventid and even so it would be nice to see this in a report or a SQL query. The reason it flipped would be even better!