Solved

SQL 2008 R2 Licensing

Posted on 2013-02-06
2
378 Views
Last Modified: 2013-02-07
I am looking to license a database-mirroring plus log-shipped secondary setup using 3 identical servers.

SQL 2008 R2 Enterprise being used and will be licensed on a 'per processor' basis.

Both the mirror and log-shipped servers will be completely passive (no reporting or database snapshotting).

On this basis, can I simply license the principal only, leaving both the mirror and log-shipped instances unlicensed (unless they exceed the 30-day limit for being in active use)?

Or does the log-shipped server need to be licensed on the basis that there is a maximum of 1 failover partner per instance?

There's some very contradictory advice flying around ....
0
Comment
Question by:campbell1972
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 38862984
According to the official Microsoft licensing guide, it sounds as though these standby servers don't need to be licensed:

http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20overview%20final.docx

In particular, this segment from page 2, referring to Database Mirroring, Failover Clustering, or Backup Log Shipping:

When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be licensed accordingly.

I interpret that to mean that, as long as you're not actively querying the passive servers for any business processes and their dedicated purpose is failover protection, you don't need to own a license for them. If you do have processes or reports accessing them, then you'd require a license for these instances.

Of course, Microsoft has certified licensing resellers particularly because it can be complicated and occasionally unclear, but this case seems pretty straightforward. Where did you see contradictory explanations that made you believe that you might be required to license those standby servers? In an official licensing document, or in some forum conversations somewhere?
0
 

Author Comment

by:campbell1972
ID: 38864712
Mostly in forums but it's reassuring to see that your interpretation of the licensing rules is the same as mine, the key points being:

the servers must be truly passive at all times
there is a 30-day limit on the passive server being active before it must be licensed

I'll run it by a licensed reseller at some point but, as you say, this does appear to be cut and dry.

Thanks for the input!
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now