We have a two node, single instance SQL Server 2000 cluster. If I do an
in-place upgrade to 2005, will it replace the binaries on both nodes, or must
I run the upgrade on each node?
Yes and No.
The SQL storage engine upgrade is cluster aware and will update all nodes
(assuming all nodes are online and working at the time of the upgrade). The
tools installer is NOT cluster aware and will have to be run on each node
independently. Personally, i prefer to load the tools first and then go
back and upgrade the engine.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"steveg" <steveg@.discussions.microsoft.com> wrote in message
news:963FDCFA-1752-4DBA-AA29-CAC4CFFDD705@.microsoft.com...
> We have a two node, single instance SQL Server 2000 cluster. If I do an
> in-place upgrade to 2005, will it replace the binaries on both nodes, or
> must
> I run the upgrade on each node?
sql
Sunday, March 25, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment