February 17, 2009 at 6:06 am
Hello,
Sql 2005 standtard a/p culster (sp2) I understand the cluster admin tool is
used to manage the services. I wondered if anyone would be so kind to post a
quick step by step procedure documenting how to install sp3 on an
active/passive cluster ?
Thanks
February 17, 2009 at 6:33 am
Hi,
I've installed without any problem.
Install it on the machine that has the instance, if you want to update the administrative tools of the second node, you must install it there too.
February 18, 2009 at 12:38 am
We doublechecked all clustered things were hosted on the same node.
(quorum + instances)
- shut down all applications that use sqlserver (because you know the instance(s) will get offline at some point(s) during the upgrade)
- Then we took a full sqlserver backup (all databases)
- launch sp3 and selected all instances and client components
- double check upgrade logs (we didn't encounter any problems)
- restart the seconde node
- extra update of cliet components (ssms) on the second node
- fail over all clustered parts
- restart the primary node
- double check all instances errorlog files
- perform some basic system tests to all instances
- take full backups after the upgrade
- perform dbmaintenance
- reactivate applications.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 18, 2009 at 5:00 am
thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply