having 2 machines, one being the principal and the second one as a mirror in case of failure of the 1st one. without witness but in High Safety mode
Is any way to check if the mirror DB was synchronised when the Principal has failed?
I need this because I'm concerned if:
1-the mirror goes down
2-the Principal does a lot of work (while mirror is down)
3-the mirror come up, and starts synchronising, while synchronizing the principal goes down
in this situation, can I detect the mirror is not up to date without a witness??
So...is there a way to check if the Mirror database is up to date while the Principal is down?
Edit: I tried to use a Event Notification, to keep track of mirroring changes, but theses notifications are asynchronous, so there is a gap I cant cover.
Is any other way?