?
Solved

sql support

Posted on 2014-11-19
6
Medium Priority
?
202 Views
Last Modified: 2014-11-25
I am trying to determine whether these builds of SQL are still supported (extended support), I appreciate there is the support life-cycle but it has allsorts of clauses about when support ends in line with future SP releases etc so I would appreciate some assistance:

SQL 2000 SP4
SQL 2005 SP4
SQL 2008 SP1
SQL 2008 R2 (no SP applied)
SQL 2012 SP2
0
Comment
Question by:pma111
[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
  • 3
  • 2
6 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 1000 total points
ID: 40451819
If you click on the product on this page http://support2.microsoft.com/gp/lifeselectindex , you will be taken to a page that lists the dates that support ends for the different versions.
0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 40451825
SQL Server 2000 isn't support since last year.
SQL Server 2005 is in the extended support period that ends in 2016.
SQL Server 2008 and 2008R2 are in the extended support period that ends in 2019. Both versions need to be in the last SP to be supported (SQL Server 2008 SP4 and 2008R2 SP3).
SQL Server 2012 it's supported until 2017. Extended period is until 2022. Last SP is SP2.
0
 
LVL 3

Author Comment

by:pma111
ID: 40452353
Does the same rule apply for 2005 that to be supported you need to be at the last sp ie sp4??
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40452359
Yes. I just didn't say nothing about that because your SQL Server 2005 has already the SP4 :)
0
 
LVL 3

Author Comment

by:pma111
ID: 40452448
So ss2012 even with no sp applied is supported?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40452464
No. You should apply SQL Server 2012 SP2 to stay supported.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.
Suggested Courses

765 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