• domstrad (10/24/2014)


    The SQL is mirrored without a witness server

    HA is performed using VMotion

    If you're mirroring the database then the HA is at the sql server level, introducing VMotion will not help.

    Essentially there shouldnt be any disconnection issue, but if however during transit from one host to another the network is breaking down you may quickly hit the mirror session timeout. You should'nt lose transactions it may just be that the transaction is still in the principal send queue.

    First thing i would do is stop VMotioning the mirror servers.

    domstrad (10/24/2014)


    We had to stop the mirror , restore the database and configure the mirror again

    How can stop this from happening

    Did you try resuming the mirror session?

    When patching a mirror node you patch the passive node first, reboot if necessary and then manually failover to the mirror as new principal. Patch the new passive node and reboot, then fail back if required.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉