witness server

  • with out witness server can we set up mirroring?

  • If automatic failover is required, then you must have a witness. Otherwise no, it is not required.

    Database Mirroring Overview

    Joie Andrew
    "Since 1982"

  • actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.

  • shohelr2003 (11/26/2012)


    actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.

    It's an option for Syncrhonous mirroring, although you can have a witness in Asynchronous mirroring Microsoft highly recommend you don't!!

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

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

  • Perry Whittle (11/26/2012)


    although you can have a witness in Asynchronous mirroring Microsoft highly recommend you don't!!

    Thank You for this information.

Viewing 5 posts - 1 through 4 (of 4 total)

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