Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker and Mirroring Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 12:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 1:35 PM
Points: 160, Visits: 524
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
Post #1339437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse