|
Home > Archive > MS SQL Server Clustering > April 2005 > SQL cluster SP3a install question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL cluster SP3a install question
|
|
| FullGUI 2005-04-05, 8:05 pm |
| We have a 2 node active/passive SQL2K cluster running on Windows 2003
server.
I would like to upgrade the cluster to SP3a for SQL2K, but my time
frame for doing so is a bit limited.
Is it possible to upgrade the passive node without affecting the active
node or disturbing the production environment, even if the upgrade goes
horribly wrong rendering the passive node unusable?
Best case: Upgrade the passive node, fail over and upgrade the active
and my customers won't notice a thing. Possible?
Thanks in advance,
Chris
| |
| Rodney R. Fournier [MVP] 2005-04-05, 8:05 pm |
| SP3a installs from the Active node (any node running a SQL instance) and
also upgrades the passive node. You have to do this for every SQL instance
you have. It's best to do this during a maintenance window.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"FullGUI" <ccuatt2@hotmail.com> wrote in message
news:1112706444.747381.130220@g14g2000cwa.googlegroups.com...
> We have a 2 node active/passive SQL2K cluster running on Windows 2003
> server.
>
> I would like to upgrade the cluster to SP3a for SQL2K, but my time
> frame for doing so is a bit limited.
>
> Is it possible to upgrade the passive node without affecting the active
> node or disturbing the production environment, even if the upgrade goes
> horribly wrong rendering the passive node unusable?
>
> Best case: Upgrade the passive node, fail over and upgrade the active
> and my customers won't notice a thing. Possible?
>
> Thanks in advance,
> Chris
>
| |
| FullGUI 2005-04-05, 8:05 pm |
| Thanks very much, kinda what I expected.
| |
| Peter Sun 2005-04-05, 8:05 pm |
| By the way,
SP3 will upgrade MSSearch to version 2.0.
If you do have FULLTEXT index, it's better to backup all of index files.
When you did the upgrade, just stop Fulltext, copy all of index files back.
Otherwise, you will have to rebuild all of index.
Good luck.
Peter
"FullGUI" <ccuatt2@hotmail.com> wrote in message
news:1112707451.083541.96190@l41g2000cwc.googlegroups.com...
> Thanks very much, kinda what I expected.
>
|
|
|
|
|