Server Licencing when Mirrored.

CapnElectric 0 Reputation points
2023-08-01T20:36:46.2133333+00:00

I was told that if you set up 2 servers up as MIRRORED, in order to use Windows Server and SQL Server, that you only need 1 licence for Windows Server and 1 for SQL Server to use on the 2 mirrored servers, as they are essentially the same machine with a redundant backup.

Is this accurate?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,255 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,707 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Dave Patrick 426.1K Reputation points MVP
    2023-08-01T20:42:54.7333333+00:00

    Is this accurate?

    Sorry, but no it isn't (windows server OS-wise)

    --please don't forget to upvote and Accept as answer if the reply is helpful--


  2. Erland Sommarskog 98,811 Reputation points
    2023-08-01T21:04:08.8733333+00:00

    I can only speak for the SQL Server part. Database mirroring is a deprecated functionality, and has been since SQL 2012 when Availability Groups were introduced.

    If I recall correctly, you can have one passive replica with your license. That is, it must be strictly passive, it cannot be a readonly secondary. If you have Software Assurance, you can have one more.

    However, for more accurate information, check the SQL Server Licensing Guide for the version of SQL Server you are using: https://www.microsoft.com/licensing/docs/view/SQL-Server

    And when in doubt, for an authoritative answer, contact a Microsoft licensing specialist.

    This is a technical forum where questions are answered by techies. Legal stuff is beyond our expertise.

    0 comments No comments

  3. Bruce (SqlWork.com) 52,491 Reputation points
    2023-08-01T21:08:37.9966667+00:00

    you will need a windows license for both servers.

    for Sqlserver it depends on the version of sqlserver. the sqlserver 2019+ license includes one fail over sql server instance. the fail-over server must be passive (no access while not primary).

    0 comments No comments