Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2010-12-29 : 04:53:43
|
| Hi I want to install new released Sql server 2005 sp4in Active passive cluster Sql instance with out affecting production.kindly suggest--Ragu ThangavelJunior Sql Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-12-29 : 11:21:11
|
| That's not possible. A service pack installation is not a rolling upgrade. It has to take the instance offline several times to complete it.To minimize downtime, what we've done in the past is move production to a different server temporarily while we patch the actual instance. Then we move back once we are done. It was just a simple connection string change on the application side, so we only needed to restart the apps to get it to work.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-12-29 : 11:50:03
|
| Tara, I just want to clear something. If there is active passive cluster, first we will install sp on passive node, once it done, we can move instance to passive node and install on previous active node which is know passive node. Once both completed, we can move instance to its original node. Please correct me if I am wrong. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SP installation