HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Does the version of a SQL Server Witness matter?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
theversionsqlwitnessdoesservermatter

Problem

Can you have a SQL Server witness in a mirror setup which has a higher SQL Server version than the mirror?

Ie. the mirror is on SQL Server 2012 Standard and the witness uses SQL Server 2014 Express.

Solution

From BOL :


•For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.)

Note: Express edition of the same sql server version is supported.

Edit: based on the comment from @Raidri

Technically it is possible to have a witness with a higher version of sql server than the 2 partners, but it is highly recommend and supported that all servers have the same VERSION of sql server running - edition can be different.


Except during an upgrade from an earlier version of SQL Server, the server instances in a mirroring session must all be running the same version of SQL Server. For example, a SQL Server 2008 witness is supported when you are upgrading from a SQL Server 2008 mirroring configuration but cannot be added to an existing or new SQL Server 2008 R2 or later mirroring configuration.

Context

StackExchange Database Administrators Q#123373, answer score: 11

Revisions (0)

No revisions yet.