July 25, 2012 at 4:39 am
Customer wants me to install SQL Server 2005 SP4 on passive node using passive switch to minimize the downtime.
How do I do it?
I had done it long time back but am not able to recollect the procedure now
July 25, 2012 at 5:30 am
Benki Chendu (7/25/2012)
Customer wants me to install SQL Server 2005 SP4 on passive node using passive switch to minimize the downtime.How do I do it?
I had done it long time back but am not able to recollect the procedure now
You use the passive switch, this updates the node without causing group failover
SQLServer2005SP4-KB955706-x86-ENU.exe /passive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2012 at 5:32 am
Perry Whittle (7/25/2012)
Benki Chendu (7/25/2012)
Customer wants me to install SQL Server 2005 SP4 on passive node using passive switch to minimize the downtime.How do I do it?
I had done it long time back but am not able to recollect the procedure now
You use the passive switch, this updates the node without causing group failover
SQLServer2005SP4-KB955706-x86-ENU.exe /passive
Do you mean I navigate to the folder which contains the setup file and run
SQLServer2005SP4-KB955706-x86-ENU.exe /passive through command prompt?
July 25, 2012 at 5:34 am
yes, open a command prompt and change to the directory where the hotfix exists then execute the hotfix EXE passing in the PASSIVE parameter as i have shown
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2012 at 5:41 am
Perry Whittle (7/25/2012)
yes, open a command prompt and change to the directory where the hotfix exists then execute the hotfix EXE passing in the PASSIVE parameter as i have shown
Thanks a lot. As always, you have been very helpful.
July 25, 2012 at 8:01 am
No problem, you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2012 at 9:31 am
I have another quick question.
If am doing the SP4 upgrade using the active node only, if the task scheduler is enabled, the binaries will be pushed onto the passive node as well.
How about CU3 update? will that also be pushed to the passive node?
July 26, 2012 at 10:51 am
Benki Chendu (7/25/2012)
I have another quick question.If am doing the SP4 upgrade using the active node only, if the task scheduler is enabled, the binaries will be pushed onto the passive node as well.
How about CU3 update? will that also be pushed to the passive node?
can someone please answer my query
July 26, 2012 at 11:00 am
If running from the active node with no switches it will update all nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2012 at 11:03 am
Perry Whittle (7/26/2012)
If running from the active node with no switches it will update all nodes
You mean the Cu3 too?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply