Mirroring

  • Can somebody explain why Mirroring not possible in Bulk recovery model

  • Akkare (6/30/2011)


    Can somebody explain why Mirroring not possible in Bulk recovery model

    The reason is DB mirroring required all the modification to send to the mirror partner that is fully logged operation (i.e full recovery model). the bulk logged may not have fully logged operation when there is any bulk operation has been done. So Bulk logged mode is not possible.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply