|
Hi, I am confused between MS SQL cumulative update & Service pack- (1) When we upgrade Service pack from lower to higher then what happen exactly, Does all cumulative will update with higher service pack? (2) What happen when we upgrade service pack 2 to direct 4 and skip 3? (3) What cumulative update contain, It contain only one phase of service pack or something else?
(comments are locked)
|
|
1) Service Packs generally contain all cumulative updates since the last service pack - for specific information check the MS support page for that particular SP, it will list what it includes. Service Packs also add extra functionality/features. 2) In most cases you can skip service packs like that as SP4 would contain all the updates since RTM. Sometimes however there are dependency paths, again these will be documented on the relevant SP support page. 3) Cumulative updates contain fixes for a number of bugs/issues. It is advised that you only apply cumulative updates if you are experiencing the issues that are directly fixed. Is any dependencies for service pack and cumulative update on existing product? What will happen in given below case: Existing Service Pack-2 Available cumulative packs- 01,02,03 I directly update cumulative pack 03, does will i get the 01 and 02 with update of 03?
Oct 27 '11 at 02:43 AM
Amardeep
Yes CU3 will include those fixes in CU1 and CU2
Oct 27 '11 at 03:03 AM
Kev Riley ♦♦
Thanks one more query What dependencies should I check before update the service pack or CU other then Application and Code.
Oct 27 '11 at 04:42 AM
Amardeep
Just test, test and test. And before you update, make sure you have a full backup of all databases, including system ones (master, msdb, model). In the extreme scenario where you need to roll back a CU or SP, these will be invaluable!
Oct 27 '11 at 04:53 AM
Kev Riley ♦♦
Thank you so much but Is there any Software and Hardware dependencies which was not with RTM?
Oct 27 '11 at 04:55 AM
Amardeep
(comments are locked)
|
