Solved

SQL 2008 R2 Licensing

Posted on 2013-02-06
2
390 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

825 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