Solved

SQL Server SP4

Posted on 2013-06-06
5
527 Views
Last Modified: 2013-06-26
We recently had a 3rd party audit of a SQL server systems, they raised a "high" risk issue in that some of the older MSSQL 2005 instances weren't at Service Pack 4 for 2005? Can anyone elaborate on what the risk is here? Is SP4 the only supported version of 2005? Or are older service pack levels still supported? When was SP4 released, and if SP 3 or earlier is no longer supported, can you elaborate when they went out of support?

Is this a high risk issue? Security issue?

Can you give a bit of a low tech management summary of what mainstream support actually gives you/is? And what technical support gives you/is?

What's the actual risk of operating a SQL installation for a service pack that is no longer under mainstream support?
0
Comment
Question by:pma111
  • 2
  • 2
5 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 39225392
SP4 for SQL Server 2005 is released in 2010 itself and you can get it from here:
http://www.microsoft.com/en-in/download/details.aspx?id=7218

And if SP4 is not applied then there won't be any support from Microsoft. But if you have applied SP4, then you extended support is available till 04/12/2016 and hence you are recommended to apply SP4 at the earliest.

More on End of Life support below:
http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/01/27/end-of-mainstream-support-for-sql-server-2005-and-end-of-service-pack-support-for-sql-server-2008-sp1.aspx
0
 
LVL 3

Author Comment

by:pma111
ID: 39225403
What's the overall risk though in not moving to Sp4? What's the impact if we don't go to SP4?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39225415
If you are not moving then you will not get support from Microsoft in case of any issues.
That would be the only major risk associated and the minor risks include the patches for issues fixed in SP4.
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 250 total points
ID: 39225515
The main risk into remaining in SP3 is the fact that your systems is currently unsupported by MS.  From memory (I may be mistaken) and regarding 2005, if you have not or do not plan onto buying extended support until 2016, you can stick to SP3 and accept to leave your system unsupported.  That said, between buying extended support and migrating directly to 2012, I would definitely put my money onto buying a new version.  Also, see if you can consolidate your application onto a more recent license to benefit from active support.

Hope this helps.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39225529
<<What's the overall risk though in not moving to Sp4? What's the impact if we don't go to SP4?>>
There should not be any but be very cautious about performance issues related to inner memory pressure. By passing from SP3 to SP4, many issues that did not exist on SP3 appeared on SP4.  Make sure you increase memory to reduce risk.

I would advise testing and making sure you can go back to SP3 even after installing.

Hope this helps.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Read about achieving the basic levels of HRIS security in the workplace.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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

15 Experts available now in Live!

Get 1:1 Help Now