Solved

sql support

Posted on 2014-11-19
6
191 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 46

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
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.

 
LVL 46

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 46

Expert Comment

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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
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…
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.
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now