With new r2 licensing, costs go up and unlimited virtualization rights on sql server 2008 enterprise edition go away. Independent of the new virtualization restrictions, sql server 2008 r2 prices have gone up. Microsoft allows customers with an active enterprise agreement and software assurance subscription to purchase and receive three years of extended security updates for sql server 2008 2008 r2. Customers with active software assurance or subscription licenses can purchase extended security updates annually for 75 percent of the full license cost of the latest version of sql server or windows server. Microsoft is offering three years of free extended security updates for 20082008 r2 server products in the cloud. Sql server 2008 r2 customers can upgrade to sql server 2012 r2 and again to sql server 2016 byol only. However, i have bookmarked following site of brent ozar sql server 2008 r2 pricing and feature changes. The first versions of products that will be available for premium assurance coverage will be sql server 2008 and 2008 r2, for which extended support is set to end in july 2019, and windows server. End of support for sql and windows server 2008 blay. Jul 08, 2019 microsoft sql server 2008 r2 reach end of support. Organizations using sql server 2008r2 and windows server 2008r2.
Earlier this summer, sql server 2008 and sql server 2008 r2 fell out of extended support from microsoft. In response, redmond says, that for many customers, the time for cloud migration has arrived. Security patch support ends for sql server 2008r2 microsoft. Sql server software assurance solutions experts exchange. Check out the microsoft sql server 2008 r2 licensing like sql server 2008 developer edition, ms sql server 2008 r2, sql server 2008 r2 standard, sql server 2008 r2 enterprise, sql server 2008 r2 workgroup, sql server 2008 standard edition, sql server 2008 r2 web, sql server 2008 r2 datacenter, sql server 2008 r2 parallel data warehousepdw, microsoft sharepoint server. Microsoft announces windows server premium assurance and.
Organizations using sql server 2008 r2 and windows server 2008 r2 products can add. Earlier this summer, sql server 2008 and sql server 2008 r2 fell. Sql server licensing quick reference guide 1 what is sold and who sells it new sql server 2008 r2 parallel data warehouse edition the new sql server 2008 r2 parallel data warehouse is a highly scalable data warehouse appliance that delivers perfor. If have software assurance and license by physical core, then entitled to unlimited virtualization i. You may renew each processor license into either a minimum of 4 cores, or into your actual core license needs, which may be greater than 4 cores per processor. Given how important cybersecurity is in federal it environments, its not at all advisable for your agency to keep using outdated software that will not receive security patches. How much do extended security updates cost for windows server and sql server 2008 and 2008 r2. Microsoft lifecycle policy offers 10 years of support 5 years of mainstream support and 5 years of extended support for 2008 and 2008 r2 versions of sql server and windows server. Licensing changes in sql server 2008 r2 sql server. If a sql server 2008 r2 customer with software assurance purchased a number of cores for their on premises environment, and is using software assurance to have a secondary passive server e.
Esus do not include technical support, but you can use an active support contract such as software assurance or premierunified support on sql server 2008 sql server 2008 r2 to get technical support on workloads covered by esus if you choose to stay onpremises. If you have bought your current sql server 2008 with software assurance supplied by most software vendors who sell ms products, then you can upgrade at no cost. Customers only receive three years of these extended security updates, instead of the six years they would have received with the old premium assurance. If you have software assurance, or another support plan, you can continue receiving technical support from microsoft on your endofsupport sql server product. Sql server 2008 r2 pricing sql authority with pinal dave.
I realize in order to upgrade sql 2008 to sql 2008 r2 i have to have software assurance or pay for new licensing. If i purchase sql server 2008 r2 enterprise for 1 cpu with sa, and then need to upgrade to 2 cpus, can i do this without having to purchase a totally new copy of sql. If you dont want to upgrade to the latest server version, you could move your windows server 20082008 r2 and sql 20082008 r2 to azure. Microsofts database releases from 2008 and 2010 reach end of extended support. Sql server licensing quick reference guide 4 licensing virtual machines under the server cal model standard and workgroup editions each server license for sql server 2008 r2 standard or workgroup permits you to run the software in one 1 ose. The annual outlay for the updates is 75% of the full license cost. Customers with software assurance or subscription licenses may purchase extended security updates for three years of security updates for sql server 2008 and 2008 r2. Faq about esu for windows server 20082008 r2 and sql. It was specifically designed for web applications without the limitations of express edition. Microsoft to offer option of 16 years of windows server, sql. How should i update sql server 2008 developer to r2.
Sql server 2008 r2 licensing changes and feature information. For customers with a license included li version of windows server or sql server, there is no additional licensing cost to upgrade. Organizations using sql server 2008 r2 and windows server 2008 r2 products can add three years of patch support via microsofts new extended security updates plans, the company announced thursday. Azure can be purchased in many ways and an sql server in azure can be operated as a database as a service in which patches or availability are accessible automatically. Microsofts general advice is that software assurance is now required to move sql server virtual machines vms from one physical host to another more frequently than microsofts 90day limit on license reassignment permits. If you already have software assurance a program that includes an extensive set of technologies, services, rights, and benefits active on your sql and windows server. If you dont have sa, then youll need to decide whether the new features in sql server 2008 r2 vs sql server 2008 will be worth the cost of upgrading, because you wont get sql 2008 r2 for free. Sql server licensing mobility without software assurance. Extended security updates for sql server and windows. What date must the software assurance be active through in order to update to sql 2008 r2.
Its just licensing, and according to what weve been told, if you want downgrade rights you need to buy software assurance. Contact your microsoft reseller or account team for more details. If a sql server 2008r2 customer with software assurance purchased a number of cores for their onpremises environment, and is using software assurance to. Ive done some reading on sql server 2008 r2 software assurance and have come across a question i cant find an answer to. Windows server premium assurance and sql server premium assurance are purchased as addons to software assurance on that product. Read more about windows server premium assurance and sql server premium assurance here. If a sql server 2008 or 2008 r2 customer with software assurance purchased a number of cores for their onpremises environment, and is using software assurance to have a secondary passive server e. Alternatively, if youre hosting on azure, you can use an azure support plan to get technical support.
Microsofts coming premium assurance for software assurance customers for windows. Extended security updates for sql server and windows server. If a sql server 2008 or 2008 r2 customer with software assurance purchased a. If a sql server 2008 and 2008 r2 customer wants to bring their own license byol, are they required to have software assurance coverage. It teams still running either version should start planning their migration strategies now to ensure that they meet the deadline. The first versions covered by premium assurance will be sql server 2008 and 2008 r2 extended support ends in july 2019 and windows server 2008 and 2008 r2 extended support ends in january 2020. For a price, microsoft will extend support for windows. Theres also some good news for customers that have active software assurance for their sql server and windows server. This guide does not supersede or replace any of the legal documentation covering sql server use. Sep 17, 2018 microsoft will end extended support for sql server 2008 and sql server 2008 r2 on july 9, 2019. Microsoft to offer option of 16 years of windows server. Scott lowe explains what you need to know about sql server 2008 r2 s licensing modifications and new editions.
For those of you who do not have software assurance, there is still hope. After all, extended support for sql server 2008 and 2008 r2 will end on july 9, 2019. No software assurance is required to take advantage of this extension. Microsoft sql server licensing simplified into 7 rules.
Customers also have the option to move their sql server 2008 2008 r2 and windows server 2008 2008 r2 workloads to azure sql database managed instance. Browse other questions tagged windows7 64bit sql server 2008 sql server 2008 r2 or ask your own question. Companies that migrate their it infrastructure and sql server to azure can buy themselves some time. Microsoft sql server 2017 standard license and software assurance open. I really would like to know if your organization is upgrading to sql server 2008 r2. Customers running 2008 or 2008 r2 versions of sql server and windows server in azure virtual machines will get extended security updates for free. Microsoft replacing premiere assurance support with new security plan. Microsoft rolls out premium assurance plans for windows. For a price, microsoft will extend support for windows server, sql server 6 more years offers premium assurance to customers who just cannot get off soontoretire software.
Microsoft is offering three years of free extended security updates for 2008 2008 r2 server products in the cloud. Sql server 2008 r2 gets an official date sql server blog. Microsoft replacing premiere assurance support with new. Sql server licensing is governed by two distinct licensing models in microsoft product use rights. According to microsoft, customers with active software assurance or subscription licenses can purchase extended security updates for approximately 75% of the onpremises license cost annually. Windows server premium assurance sql server premium assurance. Sql 2008 r2 for upgrade software assurance has to be. End of support for windows server 20082008 r2 and sql server. Why sql server 2008s end of life should be on feds minds. Windows and sql server 2008 and 2008 r2 end of life coming. Microsoft will end extended support for sql server 2008 and sql server 2008 r2 on july 9, 2019. For instance, windows server 2008 r2 loses extended support on jan. Extended support ending for sql server 20082008 r2 and.
This option is available to customers with software assurance coverage for the servers that require extended security support. Software assurance on the sql 2008 r2 license since. Per offering windows server premium assurance sql server premium assurance eligible products. Before making a hasty decision, identify and inventory all of your apps and server roles running on sql server 2008 and 2008 r2. Since microsoft is ending its extended support offering for sql server 2008 and 2008 r2 and windows server 2008 and 2008 r2, there are some options that you can explore. If youve got software assurance for your sql server 2008 licensing, then you get all r2 updates included for free. Faq about esu for windows server 20082008 r2 and sql server. Windows server 2008 2008 r2 and sql 2008 2008 r2 were the ones set to take advantage of the premium assurance offer. Mar 08, 2010 however, i have bookmarked following site of brent ozar sql server 2008 r2 pricing and feature changes. Sql server 2008 support and 2008 r2 support ending in 2019. Announcing new options for sql server 2008 and windows server.
With software assurance coverage on the servers, the azure hybrid. Yes, customers need to have software assurance to take advantage of the byol program for sql server on azure virtual machines as part of the license mobility program. When you have software assurance sa attached your licenses, you will. Active software assurance on your servers for all eligible licenses.
To support sql server 2008 version, you have through june 2019 to purchase this offering. Microsoft customers with software assurance can use the socalled azure hybrid benefit to move their sql. Sql server 2008 r2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve it and developer efficiency, and enable highly scalable and well managed business intelligence on a selfservice basis for your users. Sep 02, 2009 if youve got software assurance for your sql server 2008 licensing, then you get all r2 updates included for free. Windows server 2008 and windows server 2008 r2 will hit their deadline on jan. How can a customer calculate the esu price of the following situation. Customers with active software assurance or subscription licenses can purchase extended security updates annually for 75 percent of the full license cost of the latest version.
What licensing programmes are eligible for extended security updates. They receive a hybrid use benefit and can save almost 80% of the costs for their virtual machines. Microsoft changes virtualization licensing for sql server. How much will extended security updates cost for windows server and sql server 2008 and 2008 r2. The new extended security updates program replaces microsofts earlier support. For instance, if you purchased enterprise licensing with unlimited virtualization, that will be honored as long as you are current with software assurance. Dec 08, 2016 microsoft to offer option of 16 years of windows server, sql server support through new premium assurance offer. Sql server 2008 r2 showcases microsofts continued commitment to business intelligence and missioncritical workloads. If you bought sql server 2008 with the software assurance option, you may apply to a free upgrade to sql server 2008 r2, but i dont know for sure. Determining sql server 2012 core licensing requirements at sa. This gives you more time to plan for end of support. What you need to know about the sql server 2008 end of life timeline microsofts lifecycle policy offers consistent, predictable guidelines for support availability through the life of various microsoft products. Microsoft this week unveiled coming licensing additions that will extend patch support for windows server or sql server products for six more years. Microsoft rolls out premium assurance plans for windows server and sql server.
Sql server 2008 and sql server 2008 r2 reached their end of support on july 9. Licensing changes in sql server 2008 r2 network world. I mean that the server windows 2008 r2 is only used for sql server 2008 r2 no file sharing, no printer sharing and is licensed per processor but it is a member server of a domain. If a sql server 2008 r2 customer with software assurance purchased a number of cores for their onpremises environment, and is using software assurance to have a secondary passive server e.
Windows server premium assurance sql server premium. Microsoft changes virtualization licensing for sql server 2008 r2. Onpremises customers with active software assurance or subscription licenses can purchase extended security updates for 75% of the full license. 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. Sql server 2008 support and 2008 r2 support ends july 9, 2019. Microsoft changes sql server 2008 r2 virtualization licensing.
Free extended security updates in azure lift and shift your sql server 2008 workloads to azure with no application code changes. Announcing new options for sql server 2008 and windows. Microsoft to offer premium assurance for servers adding 6 years. I think brent has answered one very interesting question there that sql server r2 is free for only who has purchased software assurance. In azure customers running windows server or sql server 2008 and 2008 r2 in an azure virtual machine will get extended security updates for no additional charges above standard vm rates. As per the policy, after the end of the extended support period there will be no patches or security updates, which may cause security risks. The only way to go backwards is by exporting your data out of a sql2014 database and them importing the data to your sql 2008 r2 box. If you have software assurance sa on sql server 2008 r2 processor licenses, you are eligible to renew into core licenses at the end of your sa term. Check out the microsoft sql server 2008 r2 licensing like sql server 2008 developer edition, ms sql server 2008 r2, sql server 2008 r2 standard, sql server 2008 r2 enterprise, sql server 2008 r2 workgroup, sql server 2008 standard edition, sql server 2008 r2 web, sql server 2008 r2 datacenter, sql server 2008 r2 parallel data warehousepdw, microsoft sharepoint server and more. Dec 11, 2018 to alleviate the stress of trying to upgrade all your existing deployments before the endofsupport deadline, microsoft will provide organizations who select this option free extended security updates for three additional years after the deadlines for sql server 2008 and 2008 r2 and windows server 2008 and 2008 r2. End of support for windows server and sql server 2008 is.
End of support for windows server 20082008 r2 and sql. These apps and roles will point you in the correct direction, based upon virtualization readiness and software usage tracking, just to name a few. Hello, sql server 2008 r2 is not an update, it is a new release. The first question many organizations ask is, can we utilize sql server 2008 without microsoft support.
937 557 644 503 33 420 72 684 435 1423 1256 213 1117 359 57 252 404 704 706 1044 917 553 51 452 303 463 1497 1457 996 190 95 991 912