Tag Info

New answers tagged

3

As noted it is based on the mode mirroring is configured to, but overall the concept of mirroring you are probably closer with statement one. However, as noted in the documentation for mirroring: Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as quickly as ...


3

Firstly I should say great question usr. Sean, Robert and Max have both correctly stated that due to the re-negotiation between the Primary and Secondary, that the correct LSN is always resolved so that there is not possibility of any discrepancy in that scenario. In response to the discussion with Shanky, in Synchronous mode, the Commit first has to occur ...



Top 50 recent answers are included