Solved

sql support

Posted on 2014-11-19
6
200 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 83

Accepted Solution

by:
Dave Baldwin earned 250 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 50

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 50

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 50

Expert Comment

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 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