What happens if a message is sent, but before acknowledgement is received from the destination, originating server fails over? Therefore the message is still in the transmission_Queue of the sending server and the acknowledgement is queued up in the destination server. When the database comes back online on the mirror server, will it attempt to send the stuff that's in the transmission_Queue? or will the ack be processed before that?
The mirror is configured in the route of the destination server.
Thanks