| Author |
Topic |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2009-01-14 : 14:42:34
|
Is there any problems with installing sp3 for sql 2005?I've heard both yes and no answers.But I trust you all.. R/P |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2009-01-14 : 15:48:46
|
| Thanks Tara,Is there any way to download CU1 or will I have to request it?R/P |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-01-16 : 03:38:00
|
| Have you installed it in production yet Tara? Any issues?- Lumbago |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-16 : 16:07:49
|
| We aren't able to install it into production until May due to the amount of downtime required. We have high availability requirements, so we have to wait until we have a large downtime such as when we move our applications to the DR site twice a year. Only things I can do before that are things that would require less than a couple of minutes of downtime in SQL Server such as failing over to other nodes in a cluster for MS security patches.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
Posted - 2009-03-25 : 09:14:29
|
| How can I tell which cumulative update package I'm currently running for 2005 SP2? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-03-26 : 13:34:27
|
| No. But since you are installing SP3, you might as well get to the latest CU for that service pack. CU2 is the latest right now. I just installed SP3+CU2 on about 10 servers last night. I've also got SP3+CU1 on about 5 servers that I did a couple of months ago. These are all test/dev/perf/stage boxes though. We haven't yet installed it on any production systems due to logistics. We were going to do it in May, but that got postponed a few months due to issues unrelated to SQL Server.You don't need to install the cumulative update packages unless you are encountering some issue that is fixed in one of them, but I like to be on the latest build if I'm already going to be installing a service pack, might as well do another 10 minute installation. CUs are cumulative, you do not need to install any previous ones.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
Posted - 2009-03-26 : 15:05:41
|
quote:
Originally posted by tkizer
No. But since you are installing SP3, you might as well get to the latest CU for that service pack. CU2 is the latest right now. I just installed SP3+CU2 on about 10 servers last night. I've also got SP3+CU1 on about 5 servers that I did a couple of months ago. These are all test/dev/perf/stage boxes though. We haven't yet installed it on any production systems due to logistics. We were going to do it in May, but that got postponed a few months due to issues unrelated to SQL Server.You don't need to install the cumulative update packages unless you are encountering some issue that is fixed in one of them, but I like to be on the latest build if I'm already going to be installing a service pack, might as well do another 10 minute installation. CUs are cumulative, you do not need to install any previous ones.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
Excellent! thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2009-05-13 : 12:56:06
|
quote:
Originally posted by tkizer
No. But since you are installing SP3, you might as well get to the latest CU for that service pack. CU2 is the latest right now. I just installed SP3+CU2 on about 10 servers last night.
Hi Tara,How long did the install take on each server?ThanksSean |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL 2005 SP3