Microsoft SQL Server R2: Choosing the Correct Edition

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

This does not cover Windows 7 or Office Download the Extended Security Updates datasheet. Learn more about lifecycle support deadlines.

On Azure: Customers who migrate workloads to Azure will have access to Extended Security Updates for both SQL Server and Windows Server and R2 for three years after the End of Support dates for no additional charge above the cost of running the virtual machine.

On-premises: Eligible customers will be able to purchase Extended Security Updates for their on-premises environment. Customers who require outside Azure where Extended Security Updates are available at no additional charge can onboard on Year 2 of Extended Security Updates.

However, if an organization did not purchase the first year of Extended Security Updates coverage, they will need to purchase both Year 1 and Year 2 Extended Security Updates. Similarly, if an organization onboards only on Year 3, they will need to purchase all three years of Extended Security Updates.

Software Assurance or an equivalent Server Subscription is required for customers to purchase Extended Security Updates on-premises. No, there are no changes to the type of updates in Extended Security Updates.

Extended Security Updates do not include new features, customer-requested non-security hotfixes, or design change requests. However, Microsoft may include non-security fixes as deemed necessary. No, there are no changes to technical support options for Extended Security Updates customers in Alternatively, if hosting on Azure, customers can use an Azure Support plan to get technical support.

For those customers who need more time to upgrade and modernize their Windows Server and SQL Server and R2 on Azure, we will now provide one additional year of free extended security updates only on Azure.

We recommend upgrading to the latest versions of our software to continue to get regular security updates, either in Azure or on-premises. However, for customers that are not able to transition to a supported version before the End of Support date, we have options to help protect data and applications during the End of Support transition:. For many customers, this is an easy first step before upgrading or modernizing with newer versions or services in Azure.

Those that decide to move to Azure SQL Managed Instance PaaS will also have access to continuous security updates, as this is a fully managed solution. These customers will also have access to Extended Security Updates on Azure for no additional charges above the cost of running the virtual machine.

Extended Security Updates for on-premises or hosted environments: Extended Security Updates will also be available for workloads running on-premises or in a hosting environment such as with another cloud provider. Product licenses and Software Assurance do not need to reside on the same enrollment. Customers can purchase Extended Security Updates only for the servers they need to cover.

Extended Security Updates can be purchased directly from Microsoft or a Microsoft licensing partner. In Azure: Customers can begin migrating workloads to Azure Virtual Machines immediately and apply regular security updates until the End of Support date. You don’t need to configure anything, and there’s no additional charge for using Extended Security Updates with Azure Virtual Machines. Extended Security Updates are available to purchase typically 3 months prior to End of Support dates with delivery of Extended Security Updates beginning after End of Support.

You can find more information about how to use Extended Security Updates here. Extended Security Updates will be distributed if and when available. SQL Server does not ship a general monthly security update. If there are situations where new SQL Server important updates will not be provided and it is deemed critical by the customer but not by MSRC, we will work with the customer on a case-to-case basis to suggest appropriate mitigation.

Software Assurance does not need to be on the same enrollment. Pricing is available on published price lists. Contact your Microsoft partner or account team for more details. The price of Extended Security Updates acquired through Microsoft resellers is set by the reseller. Pricing for Windows Server Extended Security Updates is based on Windows Server Standard per core pricing, based on the number of virtual cores in the hosted virtual machine, and subject to a minimum of 16 licenses per instance.

Pricing for SQL Server Extended Security Updates is based on SQL Server per core pricing, based on the number of virtual cores in the hosted virtual machine, and subject to a minimum of 4 licenses per instance. Software Assurance is not required.

Contact your Microsoft reseller or account team for more details. If they licensed 8 cores for SQL Server on-premises and use Software Assurance benefits to have a secondary passive server i. Customers can then apply updates to their production workload on-premises and the secondary passive server i. On—premises: Yes, Software Assurance is required for on-premises workloads. Azure Hybrid Benefit—hybrid cloud Microsoft Azure.

However, they can move their workloads to Azure and get the Extended Security Updates for no additional charges above the cost of using the Azure service. Customers with Software Assurance through other enrollments e. Pricing for Extended Security Updates will follow the current license model for the server. For example, Windows Server is licensed by core and is required for all physical cores on each server.

Customers cannot buy partial periods e. EA and Extended Security Updates must overlap for at least one month at the beginning of each year of Extended Security Updates coverage. Customers must have active Software Assurance coverage or subscription licenses for at least one month at the start of each coverage period in order to be eligible for Extended Security Updates in that period. If customers purchase Extended Security Updates while Software Assurance is active, but Software Assurance lapses before the Extended Security Update coverage period begins, customers will not be able to receive updates.

Extended Security Updates are available annually, for a fixed month period. If a customer purchases Extended Security Updates in month 10 of the month period, that customer would still need to purchase the full 12 months. Customers must have purchased coverage for year 1 of Extended Security Updates in order to buy year 2, and coverage in year 2 in order to buy year 3.

Customers may buy coverage for previous years at the same time they buy coverage for a current period. It is not necessary to buy a certain period of coverage within that coverage period. Premier Support is not a base requirement, but an additional support contract is recommended if technical support will be required.

Core licenses are sold in packs of two a 2-pack of Core Licenses , and packs of 16 a pack of Core Licenses. Each processor needs to be licensed with a minimum of eight cores four 2-pack Core Licenses. Each physical server, including single-processor servers, will need to be licensed with a minimum of 16 Core Licenses eight 2-pack of Core Licenses or one pack of Core Licenses.

Additional cores can then be licensed in increments of two cores one 2-pack of Core Licenses for servers with core densities higher than 8. Customers cannot license individual Windows Server virtual machines. They must license the full physical server. Licensing requirements for Extended Security Updates on-premises align to the licensing requirements for the underlying Software Assurance coverage or subscription.

Customers will only need to know their Windows Server license position for a given server, to know how many Extended Security Update licenses they need. Customers who have covered all the underlying cores of the physical server with Windows Server Datacenter licenses should buy Extended Security Updates for the number of physical cores, irrespective of the number of VMs running on that physical server. Customers who have covered all the underlying cores of the physical server with Windows Server Standard licenses should buy Extended Security Updates for the number of physical cores, but will only be licensed to run and update two virtual machines on the server.

Customers who wish to run and update more than two virtual machines on a server licensed with Windows Server Standard must re-license all of the physical cores on the server with both Windows Server Standard and Extended Security Updates for each additional pair of virtual machines. Microsoft will only produce updates which can be applied on the latest Service Pack.

For customers who do not have Software Assurance, the alternative option to get access to Extended Security Updates is to migrate to Azure. For variable workloads, we recommend that customers migrate on Azure via Pay-As-You-Go, which allows for scaling up or down at any time.

For predictable workloads, we recommend that customers migrate to Azure via Server Subscription and Reserved Instances. Licenses and Software Assurance do not need to be on the same agreement.

However, we recommend customers complete migration before the End of Support date so that they do not miss any Extended Security Updates.

If customers miss a year of Extended Security Updates coverage, they may buy coverage for previous years at the same time they buy coverage for a current period. Yes, customers can start a new , R2, , or R2 instance on Azure and have access to Extended Security Updates. Customers who purchase Extended Security Updates for production servers may also apply those security updates to servers licensed under Visual Studio MSDN subscriptions at no additional cost.

There is no limit to the number of MSDN servers a customer can cover. Premium Assurance is no longer available, but we will honor the terms of Premium Assurance for customers who already purchased it. Software Assurance is required as a pre-requisite to Extended Security Updates.

Extended Security Updates coverage is not required to be co-terminus with Software Assurance coverage, but customers must have at least one month of qualifying Software Assurance coverage remaining at the time a given year of Extended Security Updates coverage is purchased. If they migrate to Azure, however, they can get support using their Azure Support Plan.

When customers have purchased Extended Security Updates and have an existing support plan:. Scenario: Support Team will work to troubleshoot customer issue Response: Yes. Scenario: Support Team will do a root cause analysis Response: No.

This program covers only the named product and the components that shipped with it. Unless explicitly stated the scope of this program does not extend to any other products or tools that the customer may be running on or with the covered product. No, customers must purchase Extended Security Updates separately. The cost of Extended Security Updates is not included in the price calculation of the Unified Support agreement. However, customers with Unified Support and Extended Security Updates can request technical support for the , R2, , or R2 servers covered by Extended Security Updates.

Onsite or proactive support will only be available to a customer if it is part of their Unified Support agreement. Yes, organizations which have purchased Extended Security Updates can submit support incidents using any Microsoft Support offering, including Unified and Premier Support.

Microsoft Partners are also able to submit tickets on behalf of their customers as long as the customer has purchased Extended Security Updates, though Partners will need a support agreement in place to do so. All customers must call Microsoft Support in order to place a request for a technical support incident. As we continue to work to fully automate the validation process, the tech routers will validate whether a customer purchased Extended Security Updates.

Once the customer is validated, a case will be created and routed to the appropriate queue for technical support. Customers should provide their Enterprise Agreement number or full customer name for validation. If an investigation determines that resolution requires product enhancement available in a recent release, then a request will be made to the customer to upgrade to a more recent release where the capability is already available.

See online servicing for more details.

 
 

 

Microsoft sql server 2008 r2 enterprise free. Microsoft SQL Server 2008 R2

 
By Mike Chapple Mike Chapple. As links are official links, you can start downloading safely and reliably. Previous Previous. Support Options. I have added all the links to each version separately. Share Flipboard Email.