Rob Rudloff
asked on
SQL 2008r2 as a witness for SQL 2014 primary/mirror ?
Hi.
Is anyone out there using SQL 2008r2 as a witness for mirroring SQL 2014 databases ?
Thanks
Is anyone out there using SQL 2008r2 as a witness for mirroring SQL 2014 databases ?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is to do with high-performance mode, not high-safety. Your scenarios are absolutely correct for high-safety.
But read about high-performance mode in :https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-operating-modes#WitnessImpactOnHighPerf
So, it is also important to consider what mode the mirroring is designed to be operating under. In high-performance mode a witness is not required
Apologies if I confused...
But read about high-performance mode in :https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-operating-modes#WitnessImpactOnHighPerf
The Impact of a Witness on High-Performance Mode
If you use Transact-SQL to configure high-performance mode, whenever the SAFETY property is set to OFF, we strongly recommend that the WITNESS property also be set to OFF. A witness can coexist with high-performance mode, but the witness provides no benefit and introduces risk.
So, it is also important to consider what mode the mirroring is designed to be operating under. In high-performance mode a witness is not required
Apologies if I confused...
the risk is the same no matter which mode the system setup is in when there is a witness.
Witness only benefit automatic transition of the principal, and there is no need to reset the mirroring config after a prior failed principal us restored to operating mode.
The risk of high-performance with or without a witness is a failure of the principal before the chAnge is seen by the mirror.
Witness only benefit automatic transition of the principal, and there is no need to reset the mirroring config after a prior failed principal us restored to operating mode.
The risk of high-performance with or without a witness is a failure of the principal before the chAnge is seen by the mirror.
Hmmm... If you can install sql server 2014, then the express edition must(?) also be installable. On the download center page it does support Windows Server 2008R2 (twice) always thought that was a typo...
I know there is a long standing problem for Express (in general) if you try to change the install path...
Would love to see the error message :)
I know there is a long standing problem for Express (in general) if you try to change the install path...
Would love to see the error message :)
ASKER
We currently have a 2008r2 witness running on an old Windows 2003 server, witnessing two SQL 2008r2 servers running on Windows 2008. We have started upgrading to SQL 2014 (since SQL 2016 is not happy on Win2008). The goal is to keep the witness where it is, but it seems like SQL 2014 Express does not install on Win2008.
I will post our results here.
thanks
Rob