What's the requirement to have a witness server added?

  • JasonO

    SSC Veteran

    Points: 234

    I have a database which is configure with High safety without failover operating mode for it's mirroring. Now I would want to add a witness to this mirroring to allow it to perform automatic failover. May I know what is the requirement for the witness server? Does this server need to have a sql server installed & having the same exact spec at the primary server?

  • anthony.green

    SSC Guru

    Points: 112404

    The server can be the smallest machine you can build and can run SQL Express. 1 CPU, few GB RAM, some disk, doesn't have to be powerful by any means and no where near as powerful as the primary/secondary boxes.

    The idea of it is to provide quorum like in a cluster setup so that it can act as the broker to ensure there is always a majority share of resources available to supply service.

  • MVDBA (Mike Vessey)


    Points: 21757

    I would advise against running in high safety mode if possible (if your mirror server falls down then you can't commit transaction on the principal) - I've always run in high performance mode... but that does require you to have enterprise edition


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

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