February 20, 2020 at 8:56 am
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?
February 20, 2020 at 9:07 am
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.
February 20, 2020 at 5:27 pm
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
MVDBA
April 22, 2020 at 11:00 am
Hi Can we host this witness server on some other server on network bu creating second instance on an existing SQL database server?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply