Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Service Broker and Mirroring Expand / Collapse
Posted Thursday, August 2, 2012 12:26 PM


Group: General Forum Members
Last Login: Tuesday, November 29, 2016 2:12 PM
Points: 166, Visits: 577
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.

Post #1339437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse