Solved

sql support

Posted on 2014-11-19
6
196 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 48

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 48

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 48

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

839 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