[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL 2008 R2 Licensing

Posted on 2013-02-06
2
Medium Priority
?
434 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

656 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