I am looking to obtain some advice on a SQL configuration. We are looking to implement a full quorum configuration with high safety for automatic failover.
What I would like to know is does this mean that in the event that if the Database on the principal instance is unavailable will it automatically be switched over the mirrored instance or does switching only happen in the event that the whole server is unavailable? Basically what I am asking here is, is automatic failover at a database level or is it on a whole server level?
Also, is it possible to have a full quorum with a witness in high safety mode and include a logging server as well? The logging server would be used to run queries against to ensure the principal server does not get overloaded. Not sure if this is possible and I would like some guidance on this, please. Or would it better to run these queries against the mirror server, again not sure if this is possible as it is my understanding that the mirrored instance is in a constant recovery mode.
I have included a visio diagram that depicts the setup that I am referring too.
Thanks for all your help with this.