In this mode, I get that it's asynchronous. Does that just mean it sends the TX over and what happens, happens? Do I at least know it hit the comms stack, or the wire or anything? Or just it will do its est. Thanks.
You are referring to the mode when transaction safety is OFF. In this case, the principal sends the log to the mirror but does not wait for acknowledgement from the mirror. So Mirror can lag the Principal under heavy load. However, if mirror is down or if Principal is not receiving the response to the periodic ping (i.e. communication stack has a problem), the principal takes database offline.
Thanks,
|||When you say 'the principal takes database offline' you mean the MIRROR right, not the Principal database which could still live and service TXs, right?
No comments:
Post a Comment