Solved

sql support

Posted on 2014-11-19
6
194 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
  • 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 47

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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 47

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 47

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
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…

776 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