We help IT Professionals succeed at work.

What's the latest version of SP3 hotfix?

luyan
luyan asked
on
I saw the following version of SP3 hotfix for SQL 2005.
- Cumulative Update Package 2 for SQL Server 2005 Service Pack 3 - build 9.00.4211
- Security Update for SQL Server 2005 Service Pack 3 - build 9.00.4053

So is it enough for just applying Cumulative Update Package 2 for SQL 2005 SP3?
Thanks!
Comment
Watch Question

Lead Software Engineer
Commented:
This web site appears to list all versions of SQL Server, including Service Packs and Hot Fixes. It also provides links to the KB article describing the update.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
The cumulative upgrade packages contain all previous patches..

See here for specifics http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Lee

Commented:
The most stable hotfix is CU1 for SQL Server 2005. Until you test CU2, dont go for applying it on production environment.

CU1 is available at the below location:

http://support.microsoft.com/kb/959195

Author

Commented:
The latest hotfix was Cumulative Update 8 for SQL Server 2005 Service Pack 3 which build 9.00.4285.
What's your suggestion for applying hotfix for SP3? CU8 or CU1?
Thanks!
Shaun KlineLead Software Engineer
Commented:
The best suggestion is to only apply the Cumulative Update to a test system, validate the issues listed as fixed, and then verify that none of your databases and applications are affected by the update. You'll also want search the web for what other people are saying about the Update. After you are sure that everything is working correctly, then you can plan for updating your production systems. Truthfully, unless you are affected by any of the items listed in the update, or you believe a security fix listed in the update is necessary, you shouldn't update.
If it ain't broke, don't fix it.

Lee

Commented:
>>What's your suggestion for applying hotfix for SP3? CU8 or CU1?

CU1 is the most stable upgrade which we have tested till now. However, if you have tested any other cumulative hotfixes duly, you can go ahead with that.