question

Randy avatar image
Randy asked

Cumulative Updates

I have installed SQL Server 2005 SP3 and everything went fine with no errors. However now I am reading that I need to load these other "Hot Fixes" or DO I ?

I was told that once I installed SQL 2005 SP3 that I need to load "Cumulative Update 1 for SQL Server 2005 Service Pack 3" and as I was reading I found out that there are Nine (9) more. (Jeez Louise that's allot of downloading and time installing)

Simplified Question to you:

1) Do I have to install all 9 Cumulative Updates (1-9) or can I just load the first one (1)? and
2) How do I know which Download to install? For example No.2 Cumulative Update has 3 downloads: a) SQL_Server_2005_SP3_Cumulative_Update_2
b) SQL_Server_2005_SP3_Cumulative_Update_2_SNAC
c) SQL_Server_2005_SP3_CU2_ASOLEDB_redist

and so forth and so on for the next 7 updates? Please advise as to the proper procedure any tips, suggestions etc.. will be greatly appreciated and to show you how GRATEFUL I am after you help me I will write a letter on our letterhead thanking you (which today no body ever writes thank you letters) and I will send it to whomever you choose or you just may put on your website or whomever you may choose to send it to.

Sincerely Grateful,

Randy Nicoll

updateservice-packcumulative-update
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

You just need Cumulative Update 9. The key is in the name 'Cumulative' - i.e. it includes everything from previous cumulative updates.

As for which one to download, the rule of thumb is - download the biggest one. The smaller ones patch subsystems only.

Also, you only need to install Cumulative Updates if you are being affected by the fixed issues. Cumulative updates go through a much less rigorous testing process than service packs, so if you're not being affected by any of the listed issues, then just wait for the next SP.

Hope that helps.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

PAH... Its either you or @Fatherjack! ;-) +1
0 Likes 0 ·
sp_lock avatar image
sp_lock answered

IMO CU's are recommended to resolved a specific issue you have that is resolved in the CU. I only install a CU if that is the case, as not as much testing is gone into CU's as service packs.

CU are just like SPs in the way you can install the last one and all the previous ones are included. i.e CU9 will include all hotfixes that are included in 1 through 8.

SNAC is the SQL Server native client and again IMO I only install if needed.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hah - sorry mate - +1 ;)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.